It would be easier to help if you could upload a sample spreadsheet, with names and any other sensitive info changed of course. To attach a spreadsheet click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window (the paperclip icon doesn't work).
That said you might try the following formula as a conditional formatting rule Applied to C18:DA382Formula:
=DATE(YEAR($A18),MONTH(C$2),DAY(C$2))=$A18
Let us know if you have any questions.
Bookmarks