Will,

When entering in the CF formula, make sure that the cell reference does
not have the $ signs. Then you can either Paste Special Formats or once
the first cell is set, click on the Format Painter (looks like a paint
brush) and highlight your other cells. By removing the $ signs (which
is the default if you select the cells when applying the CF formula) it
will change the cell references accordingly.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=560821