Spreadsheet Conditional Formatting ?

Hi, I am new to the forum and came here in hopes to get this specific question answered. I am attempting to automate a type of accounting activitity that takes place daily at work. We have distributors who adjust their loads based on what they ordered and this can include product that never arrived, got damaged, or is otherwise unacceptable. At the end of each day each product needs to have a total for each category after all the data is compiled in receipts from 30 separate distributors.

I made a spread threat that has each product listed in a row and distributors product amounts including each subsection listed in columns. The spread sheet sums the total for each product in each category.

Now for the problem. I would like to autofill a document report based on the values in the spreadsheet, but I don't want to include all the products that have no adjustments for the day. How can I autofill the text of the product when the value of the adjustments associated with that product is greater or less than 0. I need the product description and quantity value to appear in the report and preferably auto sort least to greatest so my biggest losses appear first

I need like a display only if kind of function