Select one or more cells in a range, table, or PivotTable report. On the Home tab, in the Style group, click the arrow next to Conditional Formatting, and then click Top/Bottom Rules. Select the command you want, such as Top 10 items or Bottom 10 %. Enter the values you want to use, and then select a format.
How do I automatically color cells in Excel based on value?
On the Home tab, in the Styles group, click Conditional Formatting > New Rule… (see step 2 of How to dynamically change a cell color based on value for step-by-step guidance). In the "New Formatting Rule" dialog, select the option "Use a formula to determine which cells to format".
How do I apply conditional formatting to multiple cells?
Steps
- Select all of the cells for which you want to apply the formatting:
- Go to the Home tab and click Conditional Formatting > New Rule...
- Select Use a formula to determine which cells to format and paste the formula that you just created.
- Click the Format button and choose the desired look for the cells. ...
- Test it out:
