ChatterBank2 mins ago
EXCEL Conditional Formatting
1 Answers
I have to use Conditional Formatting to change the colour of a row of data in excel. If the cell is labelled as GREEN, the text appears, if the label is AMBER, YELLOW or WHITE, then the text doesn't appear (i.e. formatted as white text).
Now, I can use CF and understand the three rule maximum, but if there a way of saying 'if it is GREEN, do this, if it is ABMBER, YELLOW or WHITE, then do something else' using & or OR in the CF formula bars?
Now, I can use CF and understand the three rule maximum, but if there a way of saying 'if it is GREEN, do this, if it is ABMBER, YELLOW or WHITE, then do something else' using & or OR in the CF formula bars?
Answers
Best Answer
No best answer has yet been selected by funkylad20. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.