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.

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 ...

As mentioned in the intro, you can use conditional formatting to make certain values stand out with colored text and backgrounds. You can, for example, indicate problem data values in red, and ...

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 ...

Understanding your data and how Excel's conditional formatting works is the key to accurately using icons to represent data.

Common wisdom says you just can't apply conditional formatting in a Google Apps spreadsheet using data from a different sheet. But here at THE Journal, we laugh in the face of wisdom, common or ...