Hi, I have a pivot table with 4 columns and the rows are color coded to yellow ,red and white. i want to dynamically snip the table in N-printing with these conditions. i want the rows with only red and yellow color in any of the columns and the value in the last column lets say sales should not be zero. thanks