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)
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)