Yes, you are correct that putting a $ in front of both the row and column
would make it an absolute reference. But from your wording I thought that's
what you wanted? You mentioned when a user copies A1, who's formatting
relies on D1, and pastes in A5, you still want the formatting to refer to
D1... in which case you will need a dollar sign around the row (i.e. D$1).
If you want the reference to REMAIN relative, you shouldn't put in any dollar
signs (i.e. D1).

Does that make sense or am I still not reading your question right?
--
Regards,
Dave


"barnett" wrote:

Hi Dave,

Actually, I want the opposite. I want the reference to stay relative even
when the user cuts and pastes.

I think putting the $ in front of the row would make it absolute even when
copying.

Barnett

"David Billigmeier" wrote:

Put the $ around the row number as well (i.e. $D$1)

Does that answer your question?

--
Regards,
Dave


"barnett" wrote:

Hi,

I have a cell, say A1, with conditional formatting based on the contents of
the cell on the same row, say, 3 columns to the right, specified with a
relative reference ($D2). When I copy the cells with the conditional
formatting up and down, the cell that determines the formatting goes with it,
which is just what I want. The formatting for A5 is based on D5, etc.

But I want my users to also be able to cut/paste these cells if they wish
and in this case, the formatting does not follow. For example, If I cut cell
A1 and paste to A5, the formatting is still based on D1, not D5.

I would think there's a way using indirect references, but I'm unable to see
the answer.

Thanks,
Barnett