Click "Conditional Formatting" in the Styles section of the Home tab on the ribbon and then click "Clear Rules" to view a list of options.

Avoid frustration and unintended formatting by learning how Excel applies conditional formatting rules.

How to create conditional formatting rules in Excel Once the custom value formats exist, you can apply them using conditional formatting rules. Right now, the format is set to General.

With the use of Excel’s conditional formatting, you can set the rules once and let Excel do the highlighting for you.

What is conditional formatting in Excel? Conditional formatting lets you transform static Excel spreadsheets into dynamic canvases of information.

If you are interested in creating your own rules for your Excel spreadsheet, then make sure to read How I use conditional formatting to automate my Excel spreadsheets like a pro.