OR Statement in Conditional Formatting

(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....

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 wrote:

(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....

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" wrote in message
...
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 wrote:

(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....

Thanks for the response Bob.

Bob Wall wrote:

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" wrote in message
...

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 wrote:


(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....