Hi,

I've been having some problems with conditional formatting in excel, let me explain what I would like to achieve.

Basically I have one column that is going to contain dates, I need this column to highlight any cell in it which doesn't match a list of specified dates in another column.

Basically, If this date [in column 1] is equal to one of these dates [in column 2] then leave the cell [colour 1] but if this date [in column 1] is not equal to one of these dates [in column 2] then turn the cell [colour 2].

I have been able to do this in terms of making the above structure work but it only takes into account the first date in column 2. I hope this is clear, any help would be greatly appreciated.