Excel fiscal year calendar color formatting based on user input from dates.

[mdjco]

I've got two different calendars set up right now, one custom built and the other based on a template. My end goal is to get one calendar that takes user input on start date and end date and colors the corresponding cells, this will serve as my task tracker to monitor different peoples tasks throughout the fiscal year. I have found other samples on this forum but they deal with linear task trackers and conditional formatting which is not really ideal in my situation as I need to be able to print out all 12 months along with the tasks on one page. My number one priority with these print outs is aesthetically pleasing.

I have attached the first calendar that I have built and it is the custom built one that uses VBA code to color the cells. I have only begun to program the first month and have not been able to get it to function correctly. If you go to the cal tab, you will notice that I have related the cells to the dates that way. Then the code parses the date from the user input and tries to color the cells based on the written function. It is also very important that the color for each task tracker is different and I foresee RGB values with writing code to change them. Any tips or guidance on where to go from here is much appreciated.

I do not know what the best method would be for a task tracker and I like what this guy did with conditional formatting (http://pedrowave.blogspot.com/2010/0...n-surface.html) but I would need the dates to go from october-october not jan-jan and span 2012-2013. Before I abandoned my vba code for conditional formatting I thought I'd get some input from the pros here.

Thanks in advance!