Conditional formatting for weekends in a monthly time sheet

[inddon]

Hello There,

I am preparing a monthly time sheet workbook.
I would like to highlight the weekends (Saturday and Sunday). If there are empty cells in the date columns, it should be greyed out as well.

The 1st cell of the month, I am entering the 1st day of the month, and the rest are calculated columns.

I have attached a sample workbook for your reference.

Could you please advice, how this could be achieved?


Thanks & regards,
Don

 

[NARAYANK991]

Hi ,

See the attached file.

Narayan

 

[inddon]

Hi ,

See the attached file.

Narayan

Hi Narayan,

Thank you for your help. It works perfect.

Regards,
Don

 

[bosco_yip]

1] Select of month from C14 dropdown list

2] C16, enter formula :

=0+(1&C14)

3] C17, formual copy across to AG17

=IF(C16="","",TEXT(C16,"ddd"))

4] Conditional Formatting >> New rule >> Use a formula…

Edit formula : =LEFT(C$17)="S"

Format cells >> Fill, choose grey colour

Applied to : =$C$16:$AG$18

Regards
Bosco