OR Statement in Conditional Formatting

[Bob Wall]

(Excel 97)
Is it possible to use an OR statement in the conditional formatting FORMULA
IS context? I'd like cells to be a certain color if certain text criteria
are entered.
(basically I am trying to go beyond the 3 condition limitation).

Example: if the user enters "Available" or "Ready", the cell background will
turn green.

If text "Not Ready" or "In Process" is entered, the cell background would be
red, etc.

Many thanks in advance....

 

[Govind]

Hi,

Go to Format -Conditional formatting.

In condition 1 choose "formula is" and enter

=OR($A$1="Available",$A$1="Ready")

Click and add and in condition 2 choose "formula is" and enter

=OR($A$1="Not Ready",$A$1="In Process")

and choose your formats accordingly.

Regards

Govind.

 

[Bob Wall]

Excellent - I messed up one of my cell references. Many thanks!

PS... I tried it with at least 5 different text strings in the OR statement,
and
it works just fine.. so this is another way to get past the minimal 3
conditions if you can use the same color/formatting for different events.

Regards,

BW

 

[Govind]

Thanks for the response Bob.

Excellent - I messed up one of my cell references. Many thanks!

PS... I tried it with at least 5 different text strings in the OR statement,
and
it works just fine.. so this is another way to get past the minimal 3
conditions if you can use the same color/formatting for different events.

Regards,

BW