Conditional Formatting Nested Formulas
I'm working with a large spreadsheet that has multiple status options. Each
status has different criteria for example:
Status Green Yellow Red
T <60 =60,<=80 80
S <20 =20,<=45 45
D <30 =30,<=55 55
C <90 =90,<=120 120
B <30 =30,<=60 60
A <10 =10,<=40 40
I would like to apply conditional formats according to the status criteria.
Is that possible given that each status has a different criterial. Thank you!
|