software

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 quot;redquot;
Cell Value is: Equal to = quot;Red's Gymquot;
Cell Value is: Equal to = quot;Net Zeroquot;
Cell Value is: Equal to = quot;Solsticequot;
Cell Value is: Equal to = quot;Nymediaquot;
Thanks in advance!!!

Hi!

That's only one condition.
Select Formula is:
Enter this formula (use the appropriate cell reference)

=OR(A1={quot;Red's Gymquot;,quot;Net Zeroquot;,quot;Solsticequot;,quot;Nymediaquot;})

Biff

quot;Richardquot; gt; wrote in message
...
gt; I'm using excel97 which only allows 3 conditional formatting. I need a
gt; fourth
gt; one! Can someone see if these can be reworded to allow for a fourth
gt; condition? Need all results to be in quot;redquot;
gt; Cell Value is: Equal to = quot;Red's Gymquot;
gt; Cell Value is: Equal to = quot;Net Zeroquot;
gt; Cell Value is: Equal to = quot;Solsticequot;
gt; Cell Value is: Equal to = quot;Nymediaquot;
gt; Thanks in advance!!!
gt;
gt;
gt;
One way:

CF1: =OR(A1=quot;Red's Gymquot;,A1=quot;Net Zeroquot;,A1=quot;Solsticequot;,A1=quot;Nymediaquot;)
Format1: Font/lt;redgt;

In article gt;,
quot;Richardquot; gt; wrote:

gt; I'm using excel97 which only allows 3 conditional formatting. I need a fourth
gt; one! Can someone see if these can be reworded to allow for a fourth
gt; condition? Need all results to be in quot;redquot;
gt; Cell Value is: Equal to = quot;Red's Gymquot;
gt; Cell Value is: Equal to = quot;Net Zeroquot;
gt; Cell Value is: Equal to = quot;Solsticequot;
gt; Cell Value is: Equal to = quot;Nymediaquot;
gt; Thanks in advance!!!

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

quot;Richardquot; wrote:

gt; I'm using excel97 which only allows 3 conditional formatting. I need a fourth
gt; one! Can someone see if these can be reworded to allow for a fourth
gt; condition? Need all results to be in quot;redquot;
gt; Cell Value is: Equal to = quot;Red's Gymquot;
gt; Cell Value is: Equal to = quot;Net Zeroquot;
gt; Cell Value is: Equal to = quot;Solsticequot;
gt; Cell Value is: Equal to = quot;Nymediaquot;
gt; Thanks in advance!!!
gt;
gt;
gt;

Hmmm, I get the quot;can't use array constants in a conditional formatquot;
error...In article gt;,
quot;Biffquot; gt; wrote:

gt; =OR(A1={quot;Red's Gymquot;,quot;Net Zeroquot;,quot;Solsticequot;,quot;Nymediaquot;})

Note: use the quot;Formula isquot; dropdown in CF1.

In article gt;,
JE McGimpsey gt; wrote:

gt; One way:
gt;
gt; CF1: =OR(A1=quot;Red's Gymquot;,A1=quot;Net Zeroquot;,A1=quot;Solsticequot;,A1=quot;Nymediaquot;)
gt; Format1: Font/lt;redgt;
gt;
gt; In article gt;,
gt; quot;Richardquot; gt; wrote:
gt;
gt; gt; I'm using excel97 which only allows 3 conditional formatting. I need a
gt; gt; fourth
gt; gt; one! Can someone see if these can be reworded to allow for a fourth
gt; gt; condition? Need all results to be in quot;redquot;
gt; gt; Cell Value is: Equal to = quot;Red's Gymquot;
gt; gt; Cell Value is: Equal to = quot;Net Zeroquot;
gt; gt; Cell Value is: Equal to = quot;Solsticequot;
gt; gt; Cell Value is: Equal to = quot;Nymediaquot;
gt; gt; Thanks in advance!!!

Ooops!

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

No problemo!

Goto Insertgt;Namegt;Define
Name: Names
Refers to: ={quot;Red's Gymquot;,quot;Net Zeroquot;,quot;Solsticequot;,quot;Nymediaquot;}
OK

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

Biff

quot;Biffquot; gt; wrote in message
...
gt; Hi!
gt;
gt; That's only one condition.
gt; Select Formula is:
gt; Enter this formula (use the appropriate cell reference)
gt;
gt; =OR(A1={quot;Red's Gymquot;,quot;Net Zeroquot;,quot;Solsticequot;,quot;Nymediaquot;})
gt;
gt; Biff
gt;
gt; quot;Richardquot; gt; wrote in message
gt; ...
gt;gt; I'm using excel97 which only allows 3 conditional formatting. I need a
gt;gt; fourth
gt;gt; one! Can someone see if these can be reworded to allow for a fourth
gt;gt; condition? Need all results to be in quot;redquot;
gt;gt; Cell Value is: Equal to = quot;Red's Gymquot;
gt;gt; Cell Value is: Equal to = quot;Net Zeroquot;
gt;gt; Cell Value is: Equal to = quot;Solsticequot;
gt;gt; Cell Value is: Equal to = quot;Nymediaquot;
gt;gt; Thanks in advance!!!
gt;gt;
gt;gt;
gt;gt;
gt;
gt;
Yeah, I caught it!

Biff

quot;JE McGimpseyquot; gt; wrote in message
...
gt; Hmmm, I get the quot;can't use array constants in a conditional formatquot;
gt; error...
gt;
gt;
gt; In article gt;,
gt; quot;Biffquot; gt; wrote:
gt;
gt;gt; =OR(A1={quot;Red's Gymquot;,quot;Net Zeroquot;,quot;Solsticequot;,quot;Nymediaquot;})
There is really only one condition:=(A1=quot;Nymediaquot;) (A1=quot;Net Zeroquot;) (A1=quot;Solsticequot;) (A1=quot;Red's Gymquot;)gt;0
--
Gary's Studentquot;Richardquot; wrote:

gt; I'm using excel97 which only allows 3 conditional formatting. I need a fourth
gt; one! Can someone see if these can be reworded to allow for a fourth
gt; condition? Need all results to be in quot;redquot;
gt; Cell Value is: Equal to = quot;Red's Gymquot;
gt; Cell Value is: Equal to = quot;Net Zeroquot;
gt; Cell Value is: Equal to = quot;Solsticequot;
gt; Cell Value is: Equal to = quot;Nymediaquot;
gt; Thanks in advance!!!
gt;
gt;
gt;