redspanna
Well-known Member
- Joined
- Jul 27, 2005
- Messages
- 1,602
- Office Version
- 365
- Platform
- Windows
Hi all,
In Cell B3 of my worksheet is the word Jan, C3:AG31 are the numbers 1:31 - this represents January - days 1-30
Is there some code or other 'quick' way of shading the cell of the days(C3:AG31) that are weekends, and also shade the correspond cells immediately below,
for example if C3 holds day1 of Jan and this is a Friday then this cell and C4 would be left unshaded, however D3 (day2) is a Saturday so this cell and D4 would be shaded as it is a weekend day
hope I have explained this and thanks in advance
In Cell B3 of my worksheet is the word Jan, C3:AG31 are the numbers 1:31 - this represents January - days 1-30
Is there some code or other 'quick' way of shading the cell of the days(C3:AG31) that are weekends, and also shade the correspond cells immediately below,
for example if C3 holds day1 of Jan and this is a Friday then this cell and C4 would be left unshaded, however D3 (day2) is a Saturday so this cell and D4 would be shaded as it is a weekend day
hope I have explained this and thanks in advance