Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Finance

Authors: Maurice D Levi

5th Edition

0415774594, 9780415774598

More Books

Students also viewed these Finance questions

Question

Define and discuss affirmative action.

Answered: 1 week ago

Question

Discuss diversity management.

Answered: 1 week ago