Conditional formatting if three conditions are true

[kacperkolodziej]

Hi! I have to do conditional formatting in one cell in excel and I've got three conditions:
1. value of this cell mustn't be bigger than 6 and smaller than one
2. value mustn't be equal "nk"
3. value mustn't be equal "zw"
If these three conditions are true, I want to use conditional formatting? Can you tell me how to do it?

 

[Ron Rosenfeld]

Hi! I have to do conditional formatting in one cell in excel and I've got three conditions:
1. value of this cell mustn't be bigger than 6 and smaller than one
2. value mustn't be equal "nk"
3. value mustn't be equal "zw"
If these three conditions are true, I want to use conditional formatting? Can you tell me how to do it?

Use a formula for the conditional formatting.

e.g. with a1 selected, you formula would be: =AND(A1<=6,A1>=1,A1<>"nk",A1<>"zw")

 

[joeu2004]

Use a formula for the conditional formatting.
e.g. with a1 selected, you formula would be:
=AND(A1<=6,A1>=1,A1<>"nk",A1<>"zw")

Nothing wrong with the formula, but the last two conditions are superfluous.
It is sufficient to write:

=AND(A1<=6,A1>=1)

Note that if A1="nk" or A1="zw", A1<=6 would be false.

I suspect the real mistake in the OP's requirements. I wonder if they are
misstated or misinterpreted. (Although my interpretation is the same as
Ron's.)

Perhaps he means:

=OR(AND(A1<=6,A1>=1),AND(ISTEXT(A1),A1<>"nk",A1<>"zw"))

But is questionable whether ISTEXT(A1) is an intended condition.

PS: The OR() expression is not necessarily the most efficient
implementation.

 

[Ron Rosenfeld]

=AND(A1<=6,A1>=1)

Note that if A1="nk" or A1="zw", A1<=6 would be false.

<splat> (sound of hand slapping forehead)