I would like to thank all of you in advance for your time and help with my question. I have started a workbook and have a product list/production sheet and an invoice. I have 127 products on my list, yet most customers only take a few at a time. I am relatively new to conditional formatting. Sheet “A” is my master production sheet, which I would like to use as my data entry point. Customers are in rows; products in columns. Sheet “B” is my invoice. Is is possible to put this into an equation? Only send to the invoice those products in row 2 with a value greater than 0? Would it be easier to put an equation into the invoice instead “only print this line(or lines) if the value in column “A” is greater than 0? The goal is to not list all 127 items on the invoice; saving ink and paper. One last thought; Would it be easier to formulate if the invoice fed the data to the production sheet, instead of the production sheet feeding the invoices, as I have it set up now? Once again, a great thank you for the help. I have learned a great deal from this site. You all are great teachers.