Hi,
I am trying to copy and paste conditional formatting. I can successfully copy the conditional formats with paste special format. However it seems to change all my relative references to absolute references in the formatting formulas. I want the references to remain relative like they do in the usual cut and paste and change when I paste them to a new location. Please help. The first rule has the formula =AND(D4/D$2*100 <=60,NOT(ISBLANK(D4))) and basically fills the cell if the results are less than or equal to 60 percent and not blank. The second rule has the formula =MOD(ROW(),2)=0 and fills the cell with blue if it is an even row. This last rule is just to make following along a row easier. Please help me.
Tom
I am trying to copy and paste conditional formatting. I can successfully copy the conditional formats with paste special format. However it seems to change all my relative references to absolute references in the formatting formulas. I want the references to remain relative like they do in the usual cut and paste and change when I paste them to a new location. Please help. The first rule has the formula =AND(D4/D$2*100 <=60,NOT(ISBLANK(D4))) and basically fills the cell if the results are less than or equal to 60 percent and not blank. The second rule has the formula =MOD(ROW(),2)=0 and fills the cell with blue if it is an even row. This last rule is just to make following along a row easier. Please help me.
Tom