I am hoping someone could assist me in trying to format recurring yearly dates based on a control set. The A1 column is a list of consecutive dates spanning multiple years. Column C4 to C10 is a control list of anniversary dates where only day and month are significant. I would like to highlight (format) any dates in the A1 column that appear in the C4 column, every year they appear. Thank you ahead of time for your assistance.
dates.gif
Bookmarks