There is really only one condition:


=(A1="Nymedia")+(A1="Net Zero")+(A1="Solstice")+(A1="Red's Gym")0
--
Gary's Student


"Richard" wrote:

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!!!