Excel's conditional formatting lets you formats cells based on the value of those cells or their formulas. Learn the basics of this amazing feature.

This is the demonstration file to accompany the article, How to use the selected value in a combo to determine conditional formatting in Excel, by Susan Harkins. From the hottest programming ...

Use a logical OR operator in conditional formatting The equality operator we used in the last section was easy to implement, but it doesn’t work as expected when applied to a single-column range.

Explore and use preset rules for conditional formatting Thanks to Microsoft’s preset rules, you don’t necessarily need to create a custom rule from scratch.

Learn how to master Excel 365 conditional formatting to transform raw data into actionable insights with this step-by-step guide.

How to create conditional formatting in Google Sheets The easiest way to set conditional formatting on Google Sheets is by using the Format option in the Google Sheets toolbar.

Learn how to create a drop-down list in Excel without or with color using conditional formatting and data validation rules.

Susan Harkins shows you how to visually identify holidays using Excel's conditional formatting feature.

Identifying duplicate data using conditional formatting One of the easiest ways to locate duplicate data in Excel is to use conditional formatting. Here's how. Step 1: Select the portion of your ...

You can easily discover the duplicate values in a Microsoft Excel spreadsheet using its conditional formatting duplicate highlighting feature.