Question
Step 1:In worksheet Part2 there is a list of salespersons and their quarterly output. You are to highlight cells using conditional formatting according to the
Step 1:In worksheet Part2 there is a list of salespersons and their quarterly output. You are to highlight cells using conditional formatting according to the rules below: (15 points) i) Below $500 Red Cell with Red Writing ii) Between $500 and $3,000 White Cell with Blue Writing iii) Above $3,000 Green Cell with Green Writing Step 2: There is also a column for when each person turned in their sales report. You are to use conditional formatting such that if the user turned in their report after 12/17/2020 a red icon is placed in the cell, and if they turned it in on or before a green icon is placed in that cell. (10 points)
Q2 | Q3 | Q4 | Date Report Turned In |
$ 387.00 | $ 2,734.00 | $ 732.00 | 12/17/2020 |
$ 3,978.00 | $ 255.00 | $ 2,335.00 | 12/21/2020 |
$ 1,144.00 | $ 1,802.00 | $ 1,634.00 | 12/4/2020 |
$ 2,897.00 | $ 1,750.00 | $ 1,129.00 | 12/2/2020 |
$ 678.00 | $ 3,784.00 | $ 1,789.00 | 12/29/2020 |
$ 3,174.00 | $ 167.00 | $ 3,614.00 | 12/25/2020 |
$ 953.00 | $ 3,937.00 | $ 1,018.00 | 12/13/2020 |
$ 440.00 | $ 3,168.00 | $ 2,679.00 | 12/2/2020 |
$ 987.00 | $ 395.00 | $ 3,638.00 | 12/2/2020 |
$ 2,258.00 | $ 1,186.00 | $ 956.00 | 12/12/2020 |
$ 1,649.00 | $ 3,551.00 | $ 845.00 | 12/15/2020 |
$ 465.00 | $ 2,084.00 | $ 1,916.00 | 12/30/2020 |
$ 395.00 | $ 2,314.00 | $ 2,475.00 | 12/31/2020 |
$ 128.00 | $ 3,112.00 | $ 3,314.00 | 12/31/2020 |
$ 839.00 | $ 3,480.00 | $ 441.00 | 12/5/2020 |
$ 3,226.00 | $ 1,470.00 | $ 54.00 | 12/27/2020 |
$ 3,206.00 | $ 3,047.00 | $ 3,082.00 | 12/26/2020 |
$ 1,611.00 | $ 643.00 | $ 2,929.00 | 12/29/2020 |
$ 1,453.00 | $ 379.00 | $ 984.00 | 12/31/2020 |
$ 2,672.00 | $ 645.00 | $ 3,612.00 | 12/15/2020 |
$ 1,426.00 | $ 1,909.00 | $ 3,431.00 | 12/2/2020 |
$ 1,523.00 | $ 543.00 | $ 3,170.00 | 12/13/2020 |
$ 1,929.00 | $ 2,817.00 | $ 1,447.00 | 12/30/2020 |
$ 237.00 | $ 3,153.00 | $ 1,643.00 | 12/8/2020 |
$ 654.00 | $ 1,767.00 | $ 2,011.00 | 12/27/2020 |
$ 3,924.00 | $ 3,152.00 | $ 2,571.00 | 12/1/2020 |
$ 3,112.00 | $ 2,875.00 | $ 351.00 | 12/20/2020 |
$ 3,861.00 | $ 3,790.00 | $ 1,081.00 | 12/21/2020 |
$ 1,302.00 | $ 1,420.00 | $ 2,531.00 | 12/9/2020 |
$ 967.00 | $ 2,577.00 | $ 2,557.00 | 12/13/2020 |
$ 3,447.00 | $ 2,524.00 | $ 992.00 | 12/1/2020 |
$ 1,486.00 | $ 2,189.00 | $ 3,666.00 | 12/24/2020 |
$ 3,761.00 | $ 2,358.00 | $ 2,146.00 | 12/17/2020 |
$ 1,279.00 | $ 3,503.00 | $ 3,409.00 | 12/12/2020 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started