With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Saturday, October 3, 2015
yogi_Conditionally Format First Instance Of Smallest 3 Values In Range C3 to P3
post by Alpha Romero Championship: https://productforums.google.com/forum/#!topic/docs/Q8hiaa0w_g0;context-place=topicsearchin/docs/category$3Aspreadsheets%7Csort:relevance%7Cspell:false Smallest 3 values without duplicates Hello,
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?