You can accomplish this with only one condition. Create a table listing the
four values that you want highlighted, say in IV2:IV5. Then create a
conditional format. With the drop-downs, make the condition 'Formula Is' and
enter the formula =not(isna(match(A1,$IV$2:$IV$4,false))), then set the
format you want. (Replace A1 with the cell in which you've entered the value
to test).
HTH. --Bruce

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