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.

About Susan Harkins

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.

Free Newsletters, In your Inbox