Question

Briefly describe a business situation where you would use any three of the eight Highlight Cells Rules sub-menu options that are found on the Conditional Formatting drop-down menu. The options are Greater Than, Less Than, Between, Equal To, Text that Contains, A Date Occurring, Duplicate Values, and More Rules.

Answer 1

A business situation in which I would use three of the eight highlighted cells rules sub-menu options is a situation in which I have to analyze the monthly sales figures of different salesman and determine their bonus, recommend them for promotions and fire them (if required).

My company sells consumer goods company and sales through salesman and sales agents constitute a large proportion of total sales. We have, on our rolls, around 50 salesmen.

In order to complete their annual appraisal I will (as the sales department manager) will analyze their monthly sales data for the last 12 months.

The options that I will use and their explanations are:

1. > (greater than): The management has decided that salesmen who have given us sales figure in excess of $100,000 (on a monthly basis) for any four months during the year will be eligible for special bonus. Thus all sales numbers will be selected and “greater than” function will be selected to highlight those cells that are > 100,000. Bonus will be decided accordingly.

2. < (less than): The management has decided that salesmen who have given sales figures of less than $10,000 for 2 or more months will be fired. Thus all sales numbers will be selected and “less than” function will be selected to highlight those cells that are< 10,000.

3. Between: The management has decided that salesman with sales figures between $10,000-$20,000 (for more than 2 months) will be given training to enable them to improve their skills.

Image for the 1st function i.e. > (greater than):