Conditional Formatting in Excel 2010

If you’re upgrading to Excel 2010, you’ve probably noticed that the Conditional Formatting feature has changed quite a bit. Now you can apply more than 3 rules, and there are fancy features like data bars and icon sets.


Intro to Conditional Formatting

I’ve updated my Intro to Conditional Formatting page, to show Excel 2010 instructions, and made a new video to show the steps. If you’re looking for Excel 2003 instructions, they’ve been moved to this page: Excel 2003 instructions.

Watch the Excel 2010 Conditional Formatting Video

To see the steps for creating two conditional formatting rules in Excel 2010, please watch this short video.


Download the Sample File

To see the sample used in this video, and other conditional formatting examples, you can visit the Conditional Formatting Introduction page.