Excel Condition to format cell depending on a range of data [Specific Dates]

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.

HI

Assuming you start in A1 and are comparing to column B, then the following code would do what you require.

=COUNTIF($B:$B,$A1)=0

Regards

Jeff

Hi,

Thanks for that, am a bit of of a novice so if you could expand on that for me a little it would be greatly appreciated.

In this instance, I want all cells D3 through D600 to contain this condition.

So D3 would need to look at a range of cells currently located in BN3 through BN27. So, if D3 is empty, it stays a certain colour, I have that condition in place fine. If D3 contains a value equal to one of those in BN3 through BN27, it stays the same colour. If D3 contains a value that is not equal to one of those in BN3 through BN27, it turns another colour.

I have been using the conditional formatting option from the format tab, how would I input the formula there?

Thanks again, the assistance is greatly appreciated