conditional formatting??

R

Richard

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

Biff

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
 
J

JE McGimpsey

One way:

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

bpeltzer

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
 
J

JE McGimpsey

Hmmm, I get the "can't use array constants in a conditional format"
error...
 
J

JE McGimpsey

Note: use the "Formula is" dropdown in CF1.

JE McGimpsey said:
One way:

CF1: =OR(A1="Red's Gym",A1="Net Zero",A1="Solstice",A1="Nymedia")
Format1: Font/<red>
Click to expand...
 
B

Biff

Ooops!

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

No problemo!

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

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

Biff
 
G

Gary''s Student

There is really only one condition:


=(A1="Nymedia")+(A1="Net Zero")+(A1="Solstice")+(A1="Red's Gym")>0
 
Top