I'm working on a spreadsheet for a client and I'm not sure of the best way to do this.
It's basically a calendar with numbers (of days) across the top, month (in jan/feb/mar format) down the side and the year in a text field (Holidays 2009 type of thing)
I can put them together to work on them as a date no problem, and I have done to work out the day as text (mon/tue/wed format). I've used conditional formatting to put the background for these day cells as gray if it's a weekend.
I now need the cell BELOW the weekend cells to be black, but I can't use conditional formatting for them because I've already used CF the max 3 times for those ones.
Is there a way I could write a macro/VBA to say 'if B8 = Sat or Sun then B9 bg = Black'?
I need it for every other row from B9:AF9 to B31:AF31.
I can write vba in access, but excel is confusing me.
Thanks for any pointers / helpful sites :o)
It's basically a calendar with numbers (of days) across the top, month (in jan/feb/mar format) down the side and the year in a text field (Holidays 2009 type of thing)
I can put them together to work on them as a date no problem, and I have done to work out the day as text (mon/tue/wed format). I've used conditional formatting to put the background for these day cells as gray if it's a weekend.
I now need the cell BELOW the weekend cells to be black, but I can't use conditional formatting for them because I've already used CF the max 3 times for those ones.
Is there a way I could write a macro/VBA to say 'if B8 = Sat or Sun then B9 bg = Black'?
I need it for every other row from B9:AF9 to B31:AF31.
I can write vba in access, but excel is confusing me.
Thanks for any pointers / helpful sites :o)
Comment