Conditional Formatting

To create a conditional formatting rule:

·         Select the desired cells for the conditional formatting rule.

·         From the Home tab, click the Conditional Formatting command. ...

·         Hover the mouse over the desired conditional formatting type, then select the desired rule from the menu that appears. ...

·         A dialog box will appear.