Hello,
i have conditional formatting on a cell. the cell will turn green based on
another cells value (if it changes to 0). so cell 1,C will be green if cell
1,F is 0.
is there a way to copy this formating and paste to cells 2,C through 20,C.
But also make the conditional formation cell to be the 2,F - 20,F. i tried
copy and paste specialformating. but it still would reference cell 1,F.

is there a way to make the conditional formatting referenced cell follow the
source cell.

thanks

Yes, in your formula use relative addressing not absolute, e.g.

=A1

not

=$A$1

--

HTH

RP
(remove nothere from the email address if mailing direct)


"greg" wrote in message
...
Hello,
i have conditional formatting on a cell. the cell will turn green based
on
another cells value (if it changes to 0). so cell 1,C will be green if
cell
1,F is 0.
is there a way to copy this formating and paste to cells 2,C through 20,C.
But also make the conditional formation cell to be the 2,F - 20,F. i
tried
copy and paste specialformating. but it still would reference cell 1,F.

is there a way to make the conditional formatting referenced cell follow
the
source cell.

thanks