Forum Discussion
Solved
Change weekend collumn background colour
Hello, I would like to change the background colour if the date says it is weekend. I now have this: It works but for a bit, I would like that only the weekends are highlighted. And that...
GKE2019 No need for a macro. Use Conditional Formatting in stead.
Select the range you want to affect , including the date header. On the Home ribbon, select Conditional formatting. Add a new rule using a formula like this:
=WEEKDAY(B$2)>=6
Where B2 is the first date in the top left corner (see picture).
GKE2019 No need for a macro. Use Conditional Formatting in stead.
Select the range you want to affect , including the date header. On the Home ribbon, select Conditional formatting. Add a new rule using a formula like this:
=WEEKDAY(B$2)>=6
Where B2 is the first date in the top left corner (see picture).