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

 

[kweaver]

Does this work for S9? Adjust for the others similarly:

=IF(OR(ISBLANK(S15),ISBLANK(Y9)),"blanks",IF(AND(S15=2,Y9=2),2,""))

 

[Hjemmet]

Thanks for trying to Help But it aint work

as i see in your code i can see you ask for "ISBLANK" on S15 and Y9 then they should be Blank to set the Conditional Format ???

i might get it wrong….

and get this error "#Name"

That i want is "IF Blank S15 or If Blank Y9 then No Conditional Formatting.....

 

[kweaver]

My code was determining if EITHER S15 or Y9 was blank, then the word "blanks" will appear in S9. You can replace that with whatever you want. Maybe

=IF(OR(ISBLANK(S15),ISBLANK(Y9)),"",IF(AND(S15=2,Y9=2),2,"")

Might help if you show some examples of what you want under various conditions.

 

[DanteAmor]

Thanks for trying to Help But it aint work

as i see in your code i can see you ask for "ISBLANK" on S15 and Y9 then they should be Blank to set the Conditional Format ???

i might get it wrong….

and get this error "#Name"

That i want is "IF Blank S15 or If Blank Y9 then No Conditional Formatting.....

In the conditional format formulas you only set the format to apply if the result of the formula is true.
In a cell you put this:
=IF(AND(S15=2;Y9=2);2)


But in the conditional format you only put this:
=AND(S15=2;Y9=2)
If the S15=2 and Y9=2 then it is true, then apply the format.


If the cells are blank then no format will be applied.

 

[Hjemmet]

Sorry But i could not get it to work

https://www.dropbox.com/s/bd723j8xxvztf1o/Cup%20System.xlsm?dl=0

 

[DanteAmor]

On the Ark1 sheet are the conditional formats

https://www.dropbox.com/s/e7c6ipxryqolwzw/Cup System.xlsm?dl=0

 

[Hjemmet]

Incredibel I Thanks So Much For the Help


Thanks to DanteAmor

 

[Hjemmet]

Hm i was toooooo Fast to say Thanks......

The code was nearly Right it just need a Or function
First Cupgame

=AND($S$15=1;[B][COLOR=#FF0000]$Y$9=1[/COLOR][/B];$Y$19=1)

it can Change $Y$9=1 or $Y$9=2
Second Cupgame

=AND($S$15=1;$Y$9=1;[B][COLOR=#ff0000]$Y$19=1[/COLOR][/B])

it can Change $Y$19=1 or $Y$19 =2
Otherwise it's looks like we get Near the right solution

 

[DanteAmor]

Try this


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