Donate SIGN UP

EXCEL Conditional Formatting

Avatar Image
funkylad20 | 12:35 Wed 20th Jan 2010 | Computers
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?
Gravatar

Answers

Only 1 answerrss feed

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.
See if this can offer you any answers:

http://www.ozgrid.com...howthread.php?t=82173

Only 1 answerrss feed

Do you know the answer?

EXCEL Conditional Formatting

Answer Question >>