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

Training: Watch and learn how to create, change, or remove conditional formatting in Excel, including how to use conditional formatting for dates and text.

How to use the IF function (combined with the AND, OR, and NOT functions) in Excel to make logical comparisons between given values.

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

To control more precisely what cells will be formatted, you can use formulas to apply conditional formatting. In this example, I am going to format the cells in the Product column if the corresponding cell in the In stock column is greater than 300. I select the cells I want to conditionally format.

Training: Show conditional formatting rules for things like the current selection or a specific worksheet. Then create, edit, and delete rules and manage the order of rules.

To control more precisely what cells will be formatted, you can use formulas to apply conditional formatting. In this example, I am going to format the cells in the Product column if the corresponding cell in the In stock column is greater than 300. I select the cells I want to conditionally format.

Conditional formatting makes it easy to highlight certain values or make particular cells easy to identify. This changes the appearance of a cell range based on a condition (or criteria). You can use conditional formatting to highlight cells that contain values which meet a certain condition.

Conditional Formatting adds visual cues, like different colors, that help you spot highs and lows or other trends. Select the cells or data range you want to format. Select Conditional Formatting. Choose one of the preset types: Highlight Cell Rules. Top/Bottom Rules. Data Bars. Color Scales. Icon Sets. Choose a criteria. Set the conditions and ...

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 has received birthday greetings from you.