conditional formatting

[Hjemmet]

Help need for this Formula in conditional formatting


S9

=IF(AND(S15=2;Y9=2);2)

S10

=IF(AND(S15=2;Y9=1);2)

S19

=IF(AND(S15=1;Y19=2);1)

S20

=IF(AND(S15=1;Y19=1);1)

I need some kind where the Conditional Not to Take Action If One of these cell's are Empty

i have Try with this

=IS.EMPTY(IF(AND(S15=2;Y9=1);1))

But it came with "False"

Hope that was enough Info

 

[Hjemmet]

Hm HM i have try you code But it came with #Name in cell and Conditonal Format aint Appear....

i try to explain it in those 4 Conditon the formula need to look like.....Maybe i didn explain it as i Ment....Sorry...

1 Condition "AND S15=1 And Y19 Is 1 (or Y9 =1;Y9=2)"
2 Condition "AND S15=1 And Y19 Is 2 (or Y9 =1;Y9=2)"
3 Condition "AND S15=2 And Y9 Is 1 (or Y19 =1;Y19=2)"
4 Condition "AND S15=2 And Y9 Is 1 (or Y19 =1;Y19=2)"

your Code was "=AND($S$15=1;OR($Y$9=1;$Y$9=2);And($Y$19=1))" i have try to change the code a Bit but wont work

 

[DanteAmor]

Hm HM i have try you code But it came with #Name in cell and Conditonal Format aint Appear....
i try to explain it in those 4 Conditon the formula need to look like.....Maybe i didn explain it as i Ment....Sorry...
1 Condition "AND S15=1 And Y19 Is 1 (or Y9 =1;Y9=2)"
2 Condition "AND S15=1 And Y19 Is 2 (or Y9 =1;Y9=2)"
3 Condition "AND S15=2 And Y9 Is 1 (or Y19 =1;Y19=2)"
4 Condition "AND S15=2 And Y9 Is 2 (or Y19 =1;Y19=2)" 'Typo error must be 2
your Code was "=AND($S$15=1;OR($Y$9=1;$Y$9=2);And($Y$19=1))" i have try to change the code a Bit but wont work

Sorry, I did not understand.

Try this:

1.
=AND($S$15=1;$Y$19=1;OR($Y$9=1;$Y$9=2))
2.
=AND($S$15=1;$Y$19=2;OR($Y$9=1;$Y$9=2))
3.
=AND($S$15=2;$Y$9=1;OR($Y$19=1;$Y$19=2))
4.
=AND($S$15=2;$Y$9=2;OR($Y$19=1;$Y$19=2))

 

[Hjemmet]

Hm i first put you New Codes in 4 different cell's

AND every one of those 4 cell's came with error #name

And also try on Conditional Formatting for each 4 cell's Nothing happend



GOT IT GOT IT GOT IT

i have Removed the "$" in the code and then it's WORK

THANK YOU SO MUCH for you Time to Figure it Out for mee

Dante Amor

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.