EXCEL Conditional Formatting

[funkylad20]

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?

[mattfox]

See if this can offer you any answers:

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