VBA to Conditionally format date range on calendar

Hi,

Looking for some advice on the best way to achieve my goal. In order to best understand what I am trying to accomplish please see the attached workbook.

Looking to have the 'Activity#' populate to the corresponding 'Start Date' cell on the calendar, then conditionally format all cells in that row until the 'End Date' of that activity is reached.

Logical issues that need to be taken into account that will ultimately shape how I accomplish this task:

• Must check cell for conditional format, if already in use move to next row, and so on until empty row is found.
• Must be able to move across and down to accommodate activities spanning more than a week.
• No same colour can be used in adjacent column(or row, unless too complex).
• After placing 'Activity#' and formatting must then colour match to the source 'Activity#'.
• Must be dynamic code, I will be using on every month of year, therefore dates will never be in same cells.

Looking for an excel vba expert to tell me whether this is worth the time/effort or if it is even possible!

If you feel that this is possible but will require a different calendar or spacing please let me know, I am open to all suggestions

Thanks,

Alain

EDIT: Example Workbook Updated See Source/Home/Jan Tabs...)

I'll use my now favourite statement..."anythings possible in VBA"

What you're looking for is definitely doable and in the format you're after.

Couple of things to check though.

1. Is this a continous calendar? ie does January follow on in the next cell to 31/12?
2. If not, are the dates involved always going to be within the month in question? *ignore that, just seen your sample data and they arent....where will the other months be? *EDIT AGAIN! Im English, we format dates properly, yours are all in December just written wrong!

Im not sure Ive covered everything in your last post, but it should be enough to be going on with, Ive slightly amended the data list just to make it easier to pull the different activities but thats a small part of the code and therefore can be amended to fit your requirements.