By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,222 Members | 1,123 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,222 IT Pros & Developers. It's quick & easy.

Excel Macro / VBA

P: 90
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)
Feb 27 '09 #1
Share this Question
Share on Google+
2 Replies

Expert 2.5K+
P: 2,653
You can handle WorkSheet Change event to apply format to cell.
Feb 27 '09 #2

P: 90
I don't know that one... But it has been a good few years since I last played with Excel properly.
I'll go Google when I get a chance.
Ta FishVal
Feb 27 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.