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