Software

10 creative uses for Excel's conditional formatting feature

Find the smallest or largest duplicate

It's easy to find the smallest or largest value using the predefined rule shown here. But you'll need a more complex rule to highlight the smallest or largest duplicate value.

About

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.