Hi All,
I have been given a spreadsheet which lists month names across the top in row 2, and days (1 - 31) down the side in Column 2 (the year name is in the worksheet tab). For example Sheet 2002!D4 is equivalent to 2nd February 2002.
I have been "asked" to change the colour of the background of the cells which correspond to weekends.
We have approx. 40 books containing 5 sheets/years worth of data.
Can anyone give me any ideas to get me started?
Regards,
Alan
I have been given a spreadsheet which lists month names across the top in row 2, and days (1 - 31) down the side in Column 2 (the year name is in the worksheet tab). For example Sheet 2002!D4 is equivalent to 2nd February 2002.
I have been "asked" to change the colour of the background of the cells which correspond to weekends.
We have approx. 40 books containing 5 sheets/years worth of data.
Can anyone give me any ideas to get me started?
Regards,
Alan