Forum Discussion
3-mo calendar - starting on a particular date
- May 06, 2022
Please test carefully.
HansVogelaar Sure! Attached.
Please test carefully.
- nmlynchMay 07, 2022Brass Contributor
Can I ask one follow-up question? I've changed some of the colors, etc. - nothing major. I also added a new tab to calculate the actual 2nd-stage window when the actual date of the 1st-stage is known. In each tab, I notice that the conditional formatting for the 2nd-stage window highlights empty cells if the window involves 2 months - cells that correspond to dates from the previous month above it. The 1st-stage window highlights only the active dates for the full two weeks - none of the inactive cells in the 2nd month. In looking at the conditional formatting, I can't figure out how to make this stop. Any thoughts?
Thank you again - I'm just blown away. You have no idea how helpful this is.
- HansVogelaarMay 07, 2022MVP
Thanks, that's my fault. I created a rule for dates before the start of the 4th month, but forgot to specify No Color as fill color.
See the attached version.
- nmlynchMay 07, 2022Brass Contributor
This works quite well!! Do I dare ask one more question? I want to highlight in dark blue the close date of the 1st window. That's no problem - I added that rule. However I run into the same problem - the date in the prior month is highlighted in addition to the date in the appropriate month. I've tried different versions of conditional formatting based on your reply above and also tried to replicate the red cell for the 2nd-stage window close. No such luck. Attaching again - asking if you might look one more time. I'm grateful for your expert help.
- nmlynchMay 06, 2022Brass ContributorWOW! You are AMAZING! I am still testing - and had to tweak something (my secondary date calculations were pulling from Today() instead of anchoring off the Day One cell) to get the 2 windows to highlight correctly. But other than that, this appears to be working perfectly. But...I will test more...and will have others do the same.
Thank you - so very very much!