I use conditional formatting a limited amount in Excel. It is great to visually highlight certain data. But It is not quite as useful as autofilter, which it seems like I use daily.
In any case, here are some good links for conditional formatting in the order of their usefulness to me:
- http://chandoo.org/wp/2008/03/13/want-to-be-an-excel-conditional-formatting-rock-star-read-this/
- Good tricks, and an excel file of the tricks.
- I especially like the up and down arrows.
- http://msdn.microsoft.com/en-us/library/bb286672(office.11).aspx
- Some improvements if you have excel 2007.
