Excel: Conditional Formatting Formula and setting Precedence
Using formula to set conditional formatting and making sure the order is correct.
Here was the questions from a colleague (she sent me an example spreadsheet to go with it):
I need A2, B2, and C2 to:
Highlight green when only e2=true
Highlight yellow when e2=true and g2=true
Highlight blue when e2=true and either i2=true or k2=true
She also gave me the possible conditions to test:
If none are true then no color.
E2 green
E2, g2 yellow
E2, g2, i2, yellow
E2, g2, k2, yellow
E2, g2, i2, k2 yellow
(G2 trumps everything)
E2, i2 blue
E2, k2 blue
E2, i2, k2 blue