Hi.
I have a list of names that I either want the column colored red, green, or yellow. Right now I have two differnet rules, one for red, and one for yellow.
so for instance yellow is =AND(B1="ABC",C1<2) and red is =AND(B1="ABC",C1>2). I will add a third for green, but my question is what is the most clean and efficient way to do this? Can this be in one giant conditional format rule or do I need to make three different ones?
TY!
Bookmarks