How do I conditional format for data that's repeated
I would like to highlight data using Conditional Formatting from a list of
numbers but only want to highlight the 2 smallest numbers.
E.g. Data list = 6,7,8,1,9,2,4,2
The result should highlight the number 1 BUT ONLY THE FIRST 2 - I don't want
both 2s highlighted.
Thanks,
|