10 creative uses for Excel's conditional formatting feature


Conditional formatting lets you apply specified formatting only when certain conditions are met. Here are some creative ways you can push conditional formatting beyond its expected uses. These techniques assume a basic knowledge of Excel's conditional formatting feature.


Note: If you'd prefer to view this information as a blog post, check out this entry in our Five Apps blog. You can also download sample Excel files that demonstrate the techniques covered here.



Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.