Conditional Formatting Excel 2016. Select the desired cells for the conditional formatting rule. To create a conditional formatting rule.
Open your document in excel. On the home tab in the style group click the arrow next to conditional formatting and then click top bottom rules. 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.
Hover the mouse over the desired conditional formatting type then select the desired rule from the menu.
How to apply conditional formatting in excel. 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. On the home tab in the style group click the arrow next to conditional formatting and then click top bottom rules. Select one or more cells in a range table or pivottable report.
