Assumption: you will be copying this CF down column C, referring to
columns A and B as in the original formatting.... That is, A2 and B2 to
calculate C2, etc.

First, you will need to edit your formulas in the Conditional Format in
C1 to remove any fixed references (i.e. '$') so that =$B$1-$A$1<=7
becomes =B1-A1<=7 and so on...

then simply copy this cell, select your desired range (C2:C200?) and
Paste SpecialFormats

Good Luck


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=375215