Ooops!

I forgot......cf formulas can't contain array constants!

No problemo!

Goto InsertNameDefine
Name: Names
Refers to: ={"Red's Gym","Net Zero","Solstice","Nymedia"}
OK

Conditional Formatting
Formula is: =OR(A1=Names)

Biff

"Biff" wrote in message
...
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!!!