Question

You have created a worksheet which tracks the sales made by the sales team.you saved it on Onedrive and shared it with the team members. You have asked them to update their sales figures on an ongoing basis. You would like to create a conditional format rule so that you can check this file at any time and be immediately aware of the top three sales figures.what would be the most effective way to do this

Answer 1

To create a conditional format rule for highlighting the top three sales figures in your worksheet, you can follow these steps:

Select the Range:

Choose the range of cells where the sales figures are located.

Go to the "Home" Tab:

Navigate to the "Home" tab in the Excel ribbon.

Conditional Formatting:

Click on "Conditional Formatting" in the ribbon.

Top/Bottom Rules:

Choose "Top 10 Items" or "Top 10%" from the dropdown menu, depending on your preference.

Set the Rule:

In the dialog box, set the value to 3 for "Top," indicating you want to highlight the top three sales figures.

Choose Formatting:

Specify the formatting options you want to apply to the top three sales figures (e.g., a specific font color, cell fill color, etc.).

Apply Rule:

Click "OK" to apply the rule.

This way, whenever you open the file, the top three sales figures will be automatically highlighted based on the conditional formatting rule you've set. This visual cue will allow you to quickly identify the highest sales performances in your team.