Hi!

That's only one condition.
Select Formula is:
Enter this formula (use the appropriate cell reference)

=OR(A1={"Red's Gym","Net Zero","Solstice","Nymedia"})

Biff

"Richard" wrote in message
...
I'm using excel97 which only allows 3 conditional formatting. I need a
fourth
one! Can someone see if these can be reworded to allow for a fourth
condition? Need all results to be in "red"
Cell Value is: Equal to = "Red's Gym"
Cell Value is: Equal to = "Net Zero"
Cell Value is: Equal to = "Solstice"
Cell Value is: Equal to = "Nymedia"
Thanks in advance!!!