Conditional Formatting Excel 2016. Select the desired cells for the conditional formatting rule. The cool thing about this kind of conditional formatting is that should you edit the numbers in the cell range so that their values fall into other categories the program automatically changes their cell formatting to suit.
Select one or more cells in a range table or pivottable report. Then hover your mouse over highlight cells rules and click duplicate values in the next pop up box that shows up choose a formatting style and click ok. 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.
Select the desired cells for the conditional formatting rule. Click the conditional formatting button on the home tab. Then hover your mouse over highlight cells rules and click duplicate values in the next pop up box that shows up choose a formatting style and click ok. From the home tab click the conditional formatting command.
