Hello,
I am requesting assistance with the following question. Thank you.
CANDIDATE - Please follow the instructions below. If you don't know how to do something, that's ok. Just skip it and put "SKIPPED" in the yellow cells under Column A for that task. ? SHEET TASK Format the header to be size 16 and bold, and freeze the top row so as you scroll down it is always in sight. Sheet 2 - Use conditional formatting so that if an OPPORTUNITY_STATE is "Won" than it turns the background green, "Lost" or "Abandoned" it turns red and "Open" it turns blue Filter so that the only August 2018 leads are visible. Determine the largest BID_AMOUNT among all the August 2018 leads and place that number in cell E1. Bold and underline that text, and make sure that it is in US dollars. Sheet 3 - Follow the instructions on this page Write a VBA function that changes the cell value of E3. Create a button on sheet 4 to increase the value by 1. Name this button "Higher". Then create a button below it that will decrease the number by 1 and name it "Lower". Save the function so we can review it. Sheet 4 - FINISHED? BID_AMOUNT 10950 21511 30125 24736 30827 OPPORTUNITY_STATE DATE_CREATED USER Lost 10-May-18 CARL Lost 9-May-18 CARL Abandoned 8-May-18 BRANDON Lost 8-May-18 CARL Abandoned 2-May-18 BRANDON ABANDONED 1-May-18 CARL Lost 1-May-18 CARL Lost 15-Jun-18 CARL Won 15-Jun-18 CASSANDRA Abandoned 9-Jun-18 CASSANDRA Lost 20-Jun-18 CASSANDRA Abandoned 25-Jun-18 CASSANDRA Lost 1-Jun-18 CASSANDRA ABANDONED 1-Jun-18 CHASE LOST 1-Jun-18 CARL LOST 4-Jun-18 CARL LOST 1-Jun-18 CARL Lost 1-Jun-18 DOUG Lost 5-Jul-18 DOUG Lost 6-Jul-18 CARL Lost 7-Jul-18 KEVIN Lost 8-Jul-18 CARL 39849 5770 42294 37622 39358 32912 LOST Abandoned WON LOST LOST Abandoned Lost Abandoned Lost LOST OPEN Lost Lost Lost OPEN Lost 9-Jul-18 CARL 10-Jul-18 CASSANDRA 11-Jul-18 BRANDON 12-Jul-18 CARL 13-Jul-18 CARL 14-Jul-18 BRANDON 5-Aug-18 CARL 5-Aug-18 DOUG 5-Aug-18 KEVIN 23-Aug-18 CARL 5-Aug-18 BRANDON 5-Aug-18 CARL 17-Aug-18 CARL 5-Aug-18 CARL 5-Aug-18 BRANDON 17-Aug-18 CARL 21118 25881 44797 35616 CANDIDATE - Please follow the instructions below. If you don't know how to do something, that's ok. Just skip it and put "SKIPPED" in the yellow cells under Column A for that task. ? SHEET TASK Format the header to be size 16 and bold, and freeze the top row so as you scroll down it is always in sight. Sheet 2 - Use conditional formatting so that if an OPPORTUNITY_STATE is "Won" than it turns the background green, "Lost" or "Abandoned" it turns red and "Open" it turns blue Filter so that the only August 2018 leads are visible. Determine the largest BID_AMOUNT among all the August 2018 leads and place that number in cell E1. Bold and underline that text, and make sure that it is in US dollars. Sheet 3 - Follow the instructions on this page Write a VBA function that changes the cell value of E3. Create a button on sheet 4 to increase the value by 1. Name this button "Higher". Then create a button below it that will decrease the number by 1 and name it "Lower". Save the function so we can review it. Sheet 4 - FINISHED? BID_AMOUNT 10950 21511 30125 24736 30827 OPPORTUNITY_STATE DATE_CREATED USER Lost 10-May-18 CARL Lost 9-May-18 CARL Abandoned 8-May-18 BRANDON Lost 8-May-18 CARL Abandoned 2-May-18 BRANDON ABANDONED 1-May-18 CARL Lost 1-May-18 CARL Lost 15-Jun-18 CARL Won 15-Jun-18 CASSANDRA Abandoned 9-Jun-18 CASSANDRA Lost 20-Jun-18 CASSANDRA Abandoned 25-Jun-18 CASSANDRA Lost 1-Jun-18 CASSANDRA ABANDONED 1-Jun-18 CHASE LOST 1-Jun-18 CARL LOST 4-Jun-18 CARL LOST 1-Jun-18 CARL Lost 1-Jun-18 DOUG Lost 5-Jul-18 DOUG Lost 6-Jul-18 CARL Lost 7-Jul-18 KEVIN Lost 8-Jul-18 CARL 39849 5770 42294 37622 39358 32912 LOST Abandoned WON LOST LOST Abandoned Lost Abandoned Lost LOST OPEN Lost Lost Lost OPEN Lost 9-Jul-18 CARL 10-Jul-18 CASSANDRA 11-Jul-18 BRANDON 12-Jul-18 CARL 13-Jul-18 CARL 14-Jul-18 BRANDON 5-Aug-18 CARL 5-Aug-18 DOUG 5-Aug-18 KEVIN 23-Aug-18 CARL 5-Aug-18 BRANDON 5-Aug-18 CARL 17-Aug-18 CARL 5-Aug-18 CARL 5-Aug-18 BRANDON 17-Aug-18 CARL 21118 25881 44797 35616
