Final answer:
Highlight Cells Rules and Top/Bottom Rules are conditional formatting commands in Excel. Highlight Cells Rules allows you to highlight cells based on specific criteria, such as greater than or containing specific text. Top/Bottom Rules highlights the highest or lowest values within a range, specifying a number or percentage.
Step-by-step explanation:
Description of Highlight Cells Rules:
In Excel, Highlight Cells Rules is a conditional formatting command that highlights cells based on specific criteria. For example, you can use this command to highlight all cells that are greater than a certain value or contain specific text.
Example:
Suppose you have a spreadsheet of students' test scores, and you want to highlight all scores that are above 90. You can use Highlight Cells Rules to achieve this by selecting the range of scores, applying the rule 'Greater Than' with a value of 90, and choosing a formatting style.
Description of Top/Bottom Rules:
The Top/Bottom Rules conditional formatting command allows you to highlight the highest or lowest values within a range. You can specify whether to highlight a specific number of top or bottom values, or a certain percentage.
Example:
Let's say you have a spreadsheet of sales data, and you want to highlight the top 5 salespeople based on their total sales. You can use the Top/Bottom Rules command, select the range of sales data, choose the 'Top' rule, specify '5' as the number of values to highlight, and apply a formatting style.