Hi all,
I have checked through some of the other conditional formatting threads but still cannot seem to solve my issue.
I am trying to set up a calendar style sheet with the weekends coloured.
the sheet is set up with the below repeated across columns (eg A-C is nov, D-F is Dec, G-I is Jan ect with days in month on the rows)
..............A..........|.....B........| C
=TEXT(B11,"ddd")|1/11/2017| Blank
At this stage the closest I can get is using the formula =OR(WEEKDAY(A11,2)=6,WEEKDAY(A11,2)=7) but it only highlights the weekends in column B and all of column C
Ideally each weekend row per month would be highlighted.
I have attached the file for more info.
Sorry if this doesn't make sense. I'm just as confused as you probably are ha.
And advice welcome here
Cheers
Wrighty
Bookmarks