Interactive Tutorial
How to Use Conditional Formatting with Formulas in Excel
4.9 out of 5 on G2
Practice live in your browser. No software required.
4 Hour Course Certificate
Free quick tips and shortcuts to use and share.
Step-by-step instructions with screenshots.
Using formulas to trigger conditional formatting gives you even more control over the presentation of your data.
The New Formatting Rule dialog box appears.
A preview of the selected format displays at the bottom of the dialog box.
The custom conditional formatting rule is saved.