One of the most common requests I receive from users is how to identify duplicate and unique values in Microsoft Excel. The easiest way I know is to apply a conditional format. In a nutshell, a ...

When you think VBA code is your only hope, try combing built-it conditional formatting tools. You might just find an easier solution than writing code.

Manually combing through spreadsheets with large datasets can be a massive headache at times. Luckily, conditional formatting exists in Microsoft Excel specifically for this reason.

Within the Conditional Formatting function, Google has provided the option of using custom formulas. These custom formulas are what you'll have to use in order to make this thing work.

Learn how to fix Excel conditional formatting issues with dynamic references, OFFSET function, and defined name method for clean spreadsheets ...

As you can see, it's not hard to use conditional formatting to get over what is blocking you from completing a task in Excel. 6 Times Excel's Conditional Formatting Saved My Sanity ...

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

Please note: This item is from our archives and was published in 2020. It is provided for historical reference. The content may be out of date and links may no longer function. Conditional formatting ...

Want to to alternate row colors in Excel? You can apply color in alternate row & column in Excel spreadsheet using Conditional Formatting.