One way:

CF1: =OR(A1="Red's Gym",A1="Net Zero",A1="Solstice",A1="Nymedia")
Format1: Font/<red

In article ,
"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!!!