hi

as a test, i copied your formula and data and pasted it into a blank

workbook. i entered the formula into CF. i then copied the cell with the CF

and pasted special > formats. all of the cells references adjusted to

reference the cell above. i think that you would be able to copied the

formating to anywhere in the workbook so long as you paste special > formats.

to make the formula static you would have to add absolute references i.e.

=(($A$2-$A$1)/$A$1)>$A$1*.2

writen as above, the cell reference would never change but you have relative

references so the formula should adjust.

try it and see. post back if it doesn't perform as expected(desired). also

post what you did.

Regards

FSt1