Simplified example:
Column A can contain two values: “back” (font color red) or “front” (font color blue).
Column B can contain two values: “up” (font color green) or “down” (font color gray).
Column C can contain any combination of those, via concatenation. (back-up, back-down, front-up, front-down)
A B C
back down back-down
back up back-up
front up front-up
back down back-down
front down front-down
I want to use conditional formatting in column C to indicate both states at once. For instance, “back-up” in column C would have font color red and background color green. “Front-down” would have font color blue, background color gray.
The necessary four conditions are all created, but only the first two in the list ever work (whichever ones I move into the top two spots). How can I get the whole list to work?
My conditions look like this:
Condition 1
Formula is A1="back"
Apply Style: back [font color red]
Condition 2
Formula is A1="front"
Apply Style: front [font color blue]
Condition 3
Formula is B1="up"
Apply Style: up [background color green]
Condition 4
Formula is B1="down"
Apply Style: down [background color gray]
Range: C1:C50