Hi, I'm working on a calender that will highlight biweekly dates based on which range of data it finds the user defined entry in A2.
For Example: I would like to put in code AHH in cell A2 and it look in range A13:B17 and D13:E17 and G13:H17 and highlight the cells of a calendar based on which range AHH was found in. (If AHH is entered in A2, The first and third Friday of the calendar will shade light green.)
I would like it not to matter if the some of the cells in the range are empty. The different ranges will also be on different sheets.
The worksheet attached is just to give an example. The actual worksheet is at work using Excel 2003 and has the entire year.
PS. Would anyone know how I can set up the calendar so it updates itself for each new year?
Thanks for looking.
Bookmarks