use formula is instead of cell value, i.e.

=B2A2


now if you copy that (format painter) it will adjust so if you copy it down
it will change to

=B3A3

across

=C2B2


if you use cell value you need to use relative references A2 as opposed to
$A$2 (it will default to absolute if you click on the cell)

cell value greater than A2


--

Regards,

Peo Sjoblom

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