Hello,
I want to color fill rows in a pivot table if the cells are <> 0. I know i can use conditional formatting to do this but i need to be able to copy and paste the data into a different worksheet with the colors still intact. Does anyone have some code that could help me?
I want to color fill rows in a pivot table if the cells are <> 0. I know i can use conditional formatting to do this but i need to be able to copy and paste the data into a different worksheet with the colors still intact. Does anyone have some code that could help me?
