Saturday, October 3, 2015

yogi_Conditionally Format First Instance Of Smallest 3 Values In Range C3 to P3

Google Spreadsheet   Post  #1978
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Oct-03-2015
post by  Alpha Romero Championship:!topic/docs/Q8hiaa0w_g0;context-place=topicsearchin/docs/category$3Aspreadsheets%7Csort:relevance%7Cspell:false
Smallest 3 values without duplicates

I'm using three conditional formatting rules to find the smallest 3 values in a row and change the background to red.

C3:P3 equal to =SMALL($C$3:$P$3,1)
C3:P3 equal to =SMALL($C$3:$P$3,2)
C3:P3 equal to =SMALL($C$3:$P$3,3)

It works fine until you have a duplicate number.

So if the row had 1,2,3,4,5 the first three would highlight red.

If the row had 1,2,3,3,5 it would highlight 1&2 and both the 3s.

Is there a way to highlight only the first occurrence of a number if there are duplicates?

Thanks in advance