The dollar sign is used for absolute reference. If you want each new
cell to have an adjusted reference then delete the dollar sign and then
the reference will adjust as you seem to want.
Ian Stephen wrote:
Hi users
I have a spreadsheet with conditional formatting references like
"Condition 1" "Formula is" "If($D$2>0)" "Cell style X"
If I copy that either by copy and paste or by using the format paintbrush
or "fill"->"down" to another row (say row 3), the reference remains "$D$2"
and I have to manually edit the conditional formatting to reference "$D$3".
This becomes very tedious when many rows are involved.
Is there a way to reference a row like "$D$THIS" or something so that the
reference always is to the row of the cell where the conditional formatting
is applied without having to manually change it in every row I add?
Thanks for any ideas!
IanS
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
