Thanks Peo but the Format Painter does not 'paint' across 'conditional
formatting'

"Peo Sjoblom" wrote:

You can just use the format painter to copy and paste formats


--

Regards,

Peo Sjoblom


"Simon L" <Simon wrote in message
...
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?