Can I use 'or' in conditional formatting?

[Father Guido]

I'd like to have 4 conditions, Red, Yellow, and Green. But I have two
conditions for green, without using two conditions for green is there
a way to use OR somehow to beat the limit?

Thanks,

Norm

PS Win2000 + XL2002

 

[Ragdyer]

Sure ... just click on "Formula Is", and you can use "OR" for more then two
conditions.

For example:

=OR(A1=2,A1=4,A1="good",A1="bad")

Will trigger the set format if "any" of the above equate to "True".

 

[Father Guido]

Thanks, that'll make my conditions easier to spot.

ØSure ... just click on "Formula Is", and you can use "OR" for more
then two
Øconditions.
Ø
ØFor example:
Ø
Ø=OR(A1=2,A1=4,A1="good",A1="bad")
Ø
ØWill trigger the set format if "any" of the above equate to "True".