Thanks Peo
Formula is... Condition 1 - Cell Value Is greater than =?????
(where =???? is the cell next door to itself)

"Peo Sjoblom" wrote:

Yes it does, you only have to use the correct formula in the conditional
formatting,
what formula are you using?

--

Regards,

Peo Sjoblom


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