I have an Excell Sheet with a calendar (months in ascending order) in the first row (N1:AK1) with the format jan-11, feb-11, mar-11, etcetera
and i have a date with the same format on a column eg. (M2:M147) I want that the cells in between the columns for the calendar and rows for the dates check the calendar and if the month in the row in which they are is after or the same as the date on their column but is sooner than 12 months after the date on the column it highlights in yellow, and i want this to be open so that if I add months to the calendar or cases (dates) they could have the same formatting.
Thank you very much.
If not clear or more information needed, please tell me. :D
Bookmarks