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".
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this communityLooks 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".
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))