conditional formatting

Hjemmet

Board Regular
Joined
Jun 20, 2018
Messages
203
Help need for this Formula in conditional formatting


S9
Code:
=IF(AND(S15=2;Y9=2);2)
S10
Code:
=IF(AND(S15=2;Y9=1);2)
S19
Code:
=IF(AND(S15=1;Y19=2);1)
S20
Code:
=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
Code:
=IS.EMPTY(IF(AND(S15=2;Y9=1);1))
But it came with "False"

Hope that was enough Info
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
Does this work for S9? Adjust for the others similarly:

Code:
=IF(OR(ISBLANK(S15),ISBLANK(Y9)),"blanks",IF(AND(S15=2,Y9=2),2,""))
 
Upvote 0
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.....
 
Last edited:
Upvote 0
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
Code:
=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.
 
Upvote 0
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.
 
Upvote 0
Sorry But i could not get it to work

Code:
https://www.dropbox.com/s/bd723j8xxvztf1o/Cup%20System.xlsm?dl=0
 
Upvote 0
Hm i was toooooo Fast to say Thanks......

The code was nearly Right it just need a Or function
First Cupgame
Code:
=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
Code:
=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


 
Upvote 0
Try this


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

Forum statistics

Threads
1,213,497
Messages
6,113,999
Members
448,541
Latest member
iparraguirre89

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top