Conditional formatting for weekend doesn't work

[Sacruzsa]

Hi everyone,
I'm having another problem with the calendar I'm developing for my shift, I'm trying to do conditional formatting on weekend days but no matter what I enter, nothing happens
used formulas =weekday($U4,2)>5 , here I always get an error message
when using ('certain text') nothing happens either, I have no idea what I'm doing wrong
As you can see the calendar is from left to right and not under each other , I have also merged 2 cells each time , I hope this is not the problem otherwise I have to start again from the beginning

Hopefully someone can help me (again)

 

[Fluff]

Try changing the commas to semi-colons.

 

[Sacruzsa]

Try changing the commas to semi-colons.

That's it, it finally works thanks

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Sacruzsa]

If I now want to conditionally format for dates that are in another sheet, is that possible?

 

[Peter_SSs]

Glad you got it working!

If I now want to conditionally format for dates that are in another sheet, is that possible?

Most likely "yes" but you would need to give us more detail about what you have, where and what you are trying to achieve. Small XL2BB samples from each sheet and explain in relation to that?