Looks like the conditional formatting skipping large formula because of the same large values.
Help me please how can I get the order what is on the picture in the column "What I would like".
-
pls share a copy of your sheet – user0 Jul 17 '19 at 16:46
-
sheet is private – user0 Jul 18 '19 at 21:04
-
docs.google.com/spreadsheets/d/… – Gina Jul 23 '19 at 15:00
red:
=C2=LARGE(INDIRECT("Sheet2!A2:A"),1)
orange:
=C2=LARGE(INDIRECT("Sheet2!A2:A"),2)
yellow:
=OR(C2=LARGE(INDIRECT("Sheet2!A2:A"),3),
C2=LARGE(INDIRECT("Sheet2!A2:A"),4))
blue:
=C2=LARGE(INDIRECT("Sheet2!A2:A"),5)
green:
=OR(C2=LARGE(INDIRECT("Sheet2!A2:A"),6),
C2=LARGE(INDIRECT("Sheet2!A2:A"),7),
C2=LARGE(INDIRECT("Sheet2!A2:A"),9))
-
Thx, but unfortunately I cannot use this. As I cannot say for fix the large 3 and 4 are going to be yellow. Maybe large 4 is going to be blue. The data behind are changing every day and today for example the large 2 and 3 are the same but large 3 and 4 are different. – Gina Jul 25 '19 at 9:49
-
