Question: Problem 5.2 Conditional Formatting Step 1: In worksheet Part2 there is a list of salespersons and their quarterly output. It is your job to assess

Problem 5.2 Conditional Formatting Step 1: InProblem 5.2 Conditional Formatting Step 1: In
Problem 5.2 Conditional Formatting Step 1: In worksheet "Part2" there is a list of salespersons and their quarterly output. It is your job to assess the data for anyone who receives a bonus. Employees get a 10% bonus of their total sales if they have total annual sales above $10,000. Employees also get a quarterly bonus of 3% if a single quarters sale is above $3,000. You are to use conditional formatting to: i) If an employee gets a quarterly bonus (single quarter above $3,000), the cell in the quarter in which they received the bonus, should be highlighted light blue with dark yellow text. ii) lfan employee gets an annual bonus (year total greater than $10,000), the Total column for that employee should be highlighted light yellow with dark green text. ii) The top 15% of total earning employees should be marked with a green flag icon in their total column. You must use conditional formatting to complete these tasks. Step 2:There is also a column for date each person turned in their sales report in December. You are to use conditional formatting such that if the user turned in their report after 12/20/2021 3 red icon with an X is placed in the cell, and if they turned it in on or before 12/20/2020 a green icon with a check is placed in that cell. (10points) \f

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!