How to Customize Conditional Formatting in Excel
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.
Free to distribute with our compliments; we hope you will consider our paid training.