please solve using excel only

Problem 5.2 Conditional Formatting 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/15/2018 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) High Due Date 3000 12/15/2018 12/1/2018 Name Longenecker, Sean Desai, Christopher Matthews, Rachel Dodds, Westley Wadsworth, Lydia Walton, Erin Wadsworth, Jeffrey Matthews, Aaron Barmer, Qian Dodds, Lindsey Goldberg, William Yang, Kalene Blum, Elizabeth Kelly, Kali Goldfarb, Benjamin knizner, Michael Walton, Jazmine Weddington, Eric Badgett, Joseph Barksdale, Brian Falsy, Rigsbee Goldberg, Benjamin Folk, Christopher Dodds, Ashley Zhao, Zachary Williams, Jace Zhao, Shane Barclay, Alicia Lloyd, Christopher Davis, Chad Folk, Paul Badgett, Max Khader. Maile Q1 Q2 Q3 04 $2,357.00 $ 387.00 $2,734.00 $ 732.00 $ 2,807.00 $3,978.00 $ 255.00 $2,335.00 $ 2,551.00 $1,144.00 $1,802.00 $1,634.00 $ 153.00 $2,897.00 $1,750.00 $1,129.00 $1,211.00 $ 678.00 $3,784.00 $1,789.00 $ 109.00 $3,174.00 $ 167.00 $3,614.00 | $ 283.00 $ 953.00 $3,937.00 $1,018.00 $1,344.00 $ 440.00 $3,168.00 $2,679.00 $2,757.00 $ 987.00 $ 395.00 $3,638.00 $2,221.00 $2,258.00 $1,186.00 $ 956.00 $2,092.00 $1,649.00 $3,551.00 $ 845.00 $ 672.00 $ 465.00 $2,084.00 $1,916.00 $3,737.00 $ 395.00 $2,314.00 $2,475.00 $ 958.00 $ 128.00 $3,112.00 $3,314.00 $1,669.00 $ 839.00 $3,480.00 $ 441.00 $ 594.00 $3,226.00 $1,470.00 $ 54.00 $ 833.00 $3,206.00 $3,047.00 $3,082.00 $3,062.00 $1,611.00 $ 643.00 $2,929.00 $ 190.00 $1,453.00 $ 379.00 $ 984.00 $2,034.00 $2,672.00 $ 645.00 $3,612.00 $1,201.00 $1,426.00 $1,909.00 $3,431.00 $ 291.00 $1,523.00 $ 543.00 $3,170.00 $ 756.00 $1,929.00 $2,817.00 $1,447.00 $3,278.00 $ 237.00 $3,153.00 $1,643.00 $ 2,008.00 $ 654.00 $1,767.00 $2,011.00 $ 173.00 $3,924.00 $3,152.00 $2,571.00 $3,345.00 $3,112.00 $2,875.00 $ 351.00 $1,435.00 $3,861.00 $3,790.00 $1,081.00 $ 1,803.00 $1,302.00 $1,420.00 $2,531.00 $1,093.00 $ 967.00 $2,577.00 $2,557.00 $ 2,896.00 $3,447.00 $2,524.00 $ 992.00 $ 959.00 $ 1,486.00 $2,189.00 $3,666.00 $3,059.00 $3,761.00 $2,358.00 $2,146.00 $3.558,00 $ 1.279.00 $3.503.00 $3.409.00 Date Report Turned In Below 12/17/2018 500 12/21/2018) 12/4/2018 12/2/2018) 12/29/2018) 12/25/2018 12/13/2018) 12/2/2018 12/2/2018) 12/12/2018 12/15/2018) 12/30/2018 12/31/2018) 12/31/2018) 12/5/2018 12/27/2018 12/26/2018) 12/29/2018 12/31/2018 12/15/2018 12/2/2018 12/13/2018) 12/30/2018 12/8/2018 12/27/2018) 12/1/2018 12/20/2018 12/21/2018 12/9/2018) 12/13/2018 12/1/2018) 12/24/2018 12/17/2018 12/12/2018 Problem 5.2 Conditional Formatting 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/15/2018 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) High Due Date 3000 12/15/2018 12/1/2018 Name Longenecker, Sean Desai, Christopher Matthews, Rachel Dodds, Westley Wadsworth, Lydia Walton, Erin Wadsworth, Jeffrey Matthews, Aaron Barmer, Qian Dodds, Lindsey Goldberg, William Yang, Kalene Blum, Elizabeth Kelly, Kali Goldfarb, Benjamin knizner, Michael Walton, Jazmine Weddington, Eric Badgett, Joseph Barksdale, Brian Falsy, Rigsbee Goldberg, Benjamin Folk, Christopher Dodds, Ashley Zhao, Zachary Williams, Jace Zhao, Shane Barclay, Alicia Lloyd, Christopher Davis, Chad Folk, Paul Badgett, Max Khader. Maile Q1 Q2 Q3 04 $2,357.00 $ 387.00 $2,734.00 $ 732.00 $ 2,807.00 $3,978.00 $ 255.00 $2,335.00 $ 2,551.00 $1,144.00 $1,802.00 $1,634.00 $ 153.00 $2,897.00 $1,750.00 $1,129.00 $1,211.00 $ 678.00 $3,784.00 $1,789.00 $ 109.00 $3,174.00 $ 167.00 $3,614.00 | $ 283.00 $ 953.00 $3,937.00 $1,018.00 $1,344.00 $ 440.00 $3,168.00 $2,679.00 $2,757.00 $ 987.00 $ 395.00 $3,638.00 $2,221.00 $2,258.00 $1,186.00 $ 956.00 $2,092.00 $1,649.00 $3,551.00 $ 845.00 $ 672.00 $ 465.00 $2,084.00 $1,916.00 $3,737.00 $ 395.00 $2,314.00 $2,475.00 $ 958.00 $ 128.00 $3,112.00 $3,314.00 $1,669.00 $ 839.00 $3,480.00 $ 441.00 $ 594.00 $3,226.00 $1,470.00 $ 54.00 $ 833.00 $3,206.00 $3,047.00 $3,082.00 $3,062.00 $1,611.00 $ 643.00 $2,929.00 $ 190.00 $1,453.00 $ 379.00 $ 984.00 $2,034.00 $2,672.00 $ 645.00 $3,612.00 $1,201.00 $1,426.00 $1,909.00 $3,431.00 $ 291.00 $1,523.00 $ 543.00 $3,170.00 $ 756.00 $1,929.00 $2,817.00 $1,447.00 $3,278.00 $ 237.00 $3,153.00 $1,643.00 $ 2,008.00 $ 654.00 $1,767.00 $2,011.00 $ 173.00 $3,924.00 $3,152.00 $2,571.00 $3,345.00 $3,112.00 $2,875.00 $ 351.00 $1,435.00 $3,861.00 $3,790.00 $1,081.00 $ 1,803.00 $1,302.00 $1,420.00 $2,531.00 $1,093.00 $ 967.00 $2,577.00 $2,557.00 $ 2,896.00 $3,447.00 $2,524.00 $ 992.00 $ 959.00 $ 1,486.00 $2,189.00 $3,666.00 $3,059.00 $3,761.00 $2,358.00 $2,146.00 $3.558,00 $ 1.279.00 $3.503.00 $3.409.00 Date Report Turned In Below 12/17/2018 500 12/21/2018) 12/4/2018 12/2/2018) 12/29/2018) 12/25/2018 12/13/2018) 12/2/2018 12/2/2018) 12/12/2018 12/15/2018) 12/30/2018 12/31/2018) 12/31/2018) 12/5/2018 12/27/2018 12/26/2018) 12/29/2018 12/31/2018 12/15/2018 12/2/2018 12/13/2018) 12/30/2018 12/8/2018 12/27/2018) 12/1/2018 12/20/2018 12/21/2018 12/9/2018) 12/13/2018 12/1/2018) 12/24/2018 12/17/2018 12/12/2018