10 creative uses for Excel's conditional formatting feature

Find the smallest or largest duplicate

As you can see above, the value 3 is the smallest value in the column, but Excel highlights each occurrence of the value 5.


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.