I have a pivot table like a square matrix ( 20 * 20). On the grand total, I applied % of row total and came up with more zeros and 100's (Because of %). Now I copied it to a new sheet used conditional formatting to highlight values > 0.01 and those values are highlighted. Is there any possibility to eliminate cells that is not highlighted?