How to use conditional formatting in Excel to visually explore, analyze, and identify patterns and trends.

You can use conditional formatting to highlight cells that contain values which meet a certain condition. Or you can format a whole cell range and vary the exact format as the value of each …

Use formulas in conditional formatting to do more than you can with the built-in rules. For example, format blank cells, or see which salespeople are selling above average, or track who …

In Excel, you can also use AND, OR and NOT to set Conditional Formatting criteria with the formula option. When you do this you can omit the IF function and use AND, OR and NOT on …

Testing whether conditions are true or false and making logical comparisons between expressions are common to many tasks. You can use the AND, OR, NOT, and IF functions to create …

What to do In the Compatibility Checker, click Find to locate cells that have conditional formatting types that are new in Excel 2007 and later, and then make the necessary changes to use only …

If the specified conditions are true when a user fills out a form that is based on your form template, the conditional formatting is displayed. You can use conditional formatting to apply bold, …

One way to apply shading to alternate rows or columns in your worksheet is by creating a conditional formatting rule. This rule uses a formula to determine whether a row is even or odd …

Learn to create and add conditional formatting rules, including using formulas, with this workbook full of examples.

To remove the excess formatting in the current worksheet, do the following: On the Inquire tab, click Clean Excess Cell Formatting. Choose whether to clean only the active worksheet or all …