You have created a worksheet which tracks the sales made by the Sales Team. You saved it in 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 efficient way to do this?

$1$ point

Select the cells where the sales figures will be entered. Go to Home, Conditional Formatting and Choose from Top$/$Bottom Rules.

Select the cells where the sales figures will be entered. Go to Home, Conditional Formatting and choose Data Bars.

Select the cells where the sales figures will be entered. Go to Home, Conditional Formatting and choose from Highlight Cell Rules.