Automatically format columns with headers of the weekend days

[vladimiratanasiu]

Hello!



I have a table with time records for the employees from a firm, as it’s shown in the linked table Time records.xlsx. Giving the different procedure from the weekend time, I need a sollution so that all columns with Sunday and Saturday headers can be automatically formatted, wherever they are placed in the table depending on the calendar.

Thank you!

 

[Fluff]

You can do that with conditional formatting using this formula

=WEEKDAY(C$4,2)>5

 

[vladimiratanasiu]

You can do that with conditional formatting using this formula

=WEEKDAY(C$4,2)>5

Thank you for your quick answer. I tried to apply the conditional formula to the whole range of cells (C4:AD13), changing also the headers dates of the April month. Unfortunately, the formatted columns are not linked with the weekend days of April, keeping their initial place (see Time records - April 2021.xlsx). How could I solve this issue? Thank you!

 

[Fluff]

As long as row 4 has valid dates then it will work whatever the month.

 

[vladimiratanasiu]

As long as row 4 has valid dates then it will work whatever the month.

Thank you, it works very well! The inaccuracy was detemined by the different language settings of my PC. I turned back to the English and the function is available now.

 

[Fluff]

You're welcome & thanks for the feedback.