Please look at the workfile.
I in essence have a matrix for company projects.
column B represents the life of a project (the life cycle). Starting in row 3 (Starting in Column C), are listed weeks of the year.
If a date in Column B falls between 2 weeks, I would like to color the cell in which the date falls.
Hopefully, the file will explain better than I can. I don't know whether to use a formula or VBA. either way, I am at a loss.
thanks for your help.