Need help with data validation, conditional formatting combination and more...

**IsiEMT** · 09-05-2011, 05:53 PM

I have attached a similar file with what I need help for. So far I got some good people from other places help me get so far, but something is not working properly...

When you open the file you'll find a layout with all days of the month. There are several formats in this file, including data validation and conditional formatting. These are not of importance with my current issue.

However, I got some good people help me set up some more automation. First, as soon as I enter the date of the first day of a month, all other days will be automatically adjusted. Also, it has been programmed that each Saturday will be greyed out cells.

Everything worked nice, but when I try to switch to September, all days in the second column are getting greyed out, not only Saturday. I'm not sure how to fix that and where exactly to problem is...

Any help will be greatly appreciated. Thanks in advance!

**jaslake** · 09-13-2011, 06:37 PM

Hi IsiEMT
As you know, the file you posted doesn't include code. It's a bit difficult to debug code if one can't see it and test it. May be why you have no responses?

**IsiEMT** · 09-13-2011, 11:34 PM

jaslake,

Thanks so much for responding. I believe you already helped me in a previous posting a while ago. Regarding the uploaded sample; as I mentioned, most of the automated things on this sheet I combined with advice of some good people like you either on this forum or elsewhere online. The problem with the automated shading on Saturday's doesn't seem to be related to a code. When you highlight the cells, you'll find the formula in Conditional Formatting > Manage Rules. Hope this will help you somewhat in figuring out the problem... Thanks!