Assuming your formula is in a cell adjacent to your data, simply hover
the mouse over the lower right corner until it changes to a plus sign
then double click. This will copy your formula (or whatever the
contents of the cell are) down to the end of the data in the adjacent
column. If it is not adjacent to data in another column, you can click
and drag the grab handle (the small square in the lower right corner of
the cell) down as far as you need.

You may want to fix the cell reference in your formula BEFORE doing
this, however, so that you continue to compare to cell F9 as such:

=IF(C5$F$9,"Suspended","") when dragged down one cell will read:
=IF(C6$F$9,"Suspended","")

HTH

Bruce


--
swatsp0p


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