Conditional format rows with differing dates

Hi,

I would like to colour rows based on the dates. As long as its a new date, it will be a different colour from the previous date.
I can't do it based on even or odd dates in the month as not all dates will be included in the range... pls see the attached file...

Hope someone out there has some clue on how to achieve this!

Any help will be greatly appreciated.

Wishing all a very HAPPY NEW YEAR!!!

Assuming your dates are in column A try this:

Select column A

Apply conditional formatting with "formula is" option and the formula

=MOD(COUNT(1/FREQUENCY(A$1:A1,A$1:A1)),2)*ISNUMBER(A1)

select format as required

OK

it works like magic!
thanks so much!!!