Hi there,

I have a set of dates in column A, and I want to highlight dates in column C if they match dates the dates in column A. I have created a defined name of the dates in column A called dates and I have tried a few things out but I can't figure it out. I want to have just one conditional rule not a rule for each cell in column C as this attached document is just a sample of what I want to do on a larger scale. I would really appreciate your support, and thanks for your help in advance.


HighlightCells.xlsx