conditional formatting??

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

[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

"Richard" <[email protected]> wrote in message
news:[email protected]...
> 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!!!
>
>
>

[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

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

[JE McGimpsey]

One way:

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

In article <[email protected]>,
"Richard" <[email protected]> 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!!!

[JE McGimpsey]

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


In article <#[email protected]>,
"Biff" <[email protected]> wrote:

> =OR(A1={"Red's Gym","Net Zero","Solstice","Nymedia"})

[JE McGimpsey]

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

In article <[email protected]>,
JE McGimpsey <[email protected]> wrote:

> One way:
>
> CF1: =OR(A1="Red's Gym",A1="Net Zero",A1="Solstice",A1="Nymedia")
> Format1: Font/<red>
>
> In article <[email protected]>,
> "Richard" <[email protected]> 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!!!

[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

"Biff" <[email protected]> wrote in message
news:%[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>> 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!!!
>>
>>
>>
>
>

[Biff]

Yeah, I caught it!

Biff

"JE McGimpsey" <[email protected]> wrote in message
news:[email protected]...
> Hmmm, I get the "can't use array constants in a conditional format"
> error...
>
>
> In article <#[email protected]>,
> "Biff" <[email protected]> wrote:
>
>> =OR(A1={"Red's Gym","Net Zero","Solstice","Nymedia"})

[Gary''s Student]

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