View Single Post
  #1   Report Post  
Putty
 
Posts: n/a
Default 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,