srikanth58
10-20-2007, 02:30 AM
Hi all,
I have a perpetual yearly calender in a 54X7 grid, using excel conditional formating I could mark week ends, public holidays and first day of the months. Now being exhausted of the conditional formatting limit provided by excel I want to know how to change the color of a range of cells, with VBA, having dates falling within turn around period of the establishment where no employee can apply leave. This turn around may be of 15 to 30 days period any where in the year and calendar cells with in this period should have different background color. Turn around period will be entered in separate cells as start date and end date.
I am really new for VBA:dunno, I would be very much relieved if the code comes with comment lines so that I understand what I am doing.
Thank you all in advance.
sri
I have a perpetual yearly calender in a 54X7 grid, using excel conditional formating I could mark week ends, public holidays and first day of the months. Now being exhausted of the conditional formatting limit provided by excel I want to know how to change the color of a range of cells, with VBA, having dates falling within turn around period of the establishment where no employee can apply leave. This turn around may be of 15 to 30 days period any where in the year and calendar cells with in this period should have different background color. Turn around period will be entered in separate cells as start date and end date.
I am really new for VBA:dunno, I would be very much relieved if the code comes with comment lines so that I understand what I am doing.
Thank you all in advance.
sri