Select entire Col "A" (assuming 1st date in Col A) click on conditional
formatting select "Cell Value Is", "not equal to" "=$B1"

that should do it. :)

"Simon L" wrote:

I have an external database that Excel queries and returns two columns of
dates. I can set up a conditional format (in one colum) so that the dates in
each row of the column change colour if the corresponding columns date is
different. My problem is how to COPY and PASTE the conditional formatting
across all dates in the one column (so that each cell looks at the date in
the corresponding cell next to it)?

Any ideas or suggestions?