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:
- Good tricks, and an excel file of the tricks.
- I especially like the up and down arrows.
- Some improvements if you have excel 2007.