3 year planner help

[scotty101]

Hi All
I am new to the forum so hello !
I need some help with putting together what is basically a list of items that need checking on certain dates over the next 3 years and I want to view in a planner so Jan - Dec for the next 3 years across the top items and dates to check down the side.

At the moment I am manually entering the dates next to the item then blocking in the date under the year / month.
What I would like to do is for the date to automatically color under the month / year.

I have seen some of your good work on calendars etc but just can't find the correct means of doing this.

Can anyone help? As you may be able to tell I am not an excel master.

Thanks

 

[gaz_chops]

Welcome to the forum.

If your Month/Year is in Row 1 and the dates are in Column A, then in conditional formatting try

=EOMONTH($A2,0)=EOMONTH(B$1,0)