I have created a calendar that auto-populates 12 calendars (one for each month). What I'm trying to do is highlight days on the calendars based on a pattern. The pattern is as follows:
X X O O X X X O O X X O O O (whereas X's are highlighted, and O's are not)
This pattern is perpetual regardless of weekends/holidays. I've been trying to figure out how to do this, without VBA. This spreadsheet is to be used on a work computer, and code is stripped from any documents due to security measures on our network. Optimally, I would like this to be dynamic, so that I can enter the pattern manually because the pattern isn't the same for every system.
To mitigate a lot of questions and confusion, I have attached the calendar in question.
Bookmarks