Hi all,

I'm trying to use OR in a piece of condition formatting. Basically, I want a cell to go red if it has either "high" or "red" in it.

I'm using the following formula, but it doesn't seem to work:

=OR("red","high")

Any ideas why this doesn't do what I want?

TIA,

SamuelT