Print only coloured rows of table

[ajc]

I am working on a table shown in the attachment as "Original table”. In
this table if “Total Reqd” >0 then the Row of that particular item
gets coloured by the CONDITIONAL FORMATTING formula.
Is there any Formula / Macro in Excel by which when I
print the original table I get only the coloured rows – As shown in
“Required table after printing”

Attachment filename: sample.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=557493

 

[Frank Kabel]

Hi
I would do this by using the same criteria as in your conditional
format 8not using the color). For this see:
http://www.rondebruin.nl/print.htm#Hide