Interactive Tutorial
How to Customize Conditional Formatting 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.
Sometimes the built-in conditional formatting options donβt meet your needs for highlighting important data. You can create custom rules to present the information in a meaningful way.
The New Formatting Rule dialog box appears.
The area below will display different fields depending on the type of rule you selected.
A preview appears at the bottom of the dialog box, so you can get a glimpse of the formatting before applying the new rule.
The new rule is created, and the formatting is applied.