Select the cell with the formatting, double click on the paint brush then
you can just select the rows you want to format, finish by pressing escape
or click the paint brush again once


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Frawst" wrote in message
...
Beege,

Thanks for the quick response.
My problem is that there's a row specific reference in the conditional
formatting, so I really need a drag and fill.