Hello,
I am trying to keep my conditional formats in my pivot table whenever I update the table.
-- I have already turned on the "Preserve cell formatting on update" under the Layout & Format tab.
-- Already tried to do a custom format under the PIVOTTABLE TOOLS --> DESIGN, but to no avail.
The table is in a tabular form and I am trying to format rows based on "Type" in the attached pivot table. I wrote a formula in column A that counts counts the rows of each type and the conditional format is looking for the "even" numbers to format.
Am I going about this the wrong way? Is a macro in order? Any help or feedback helps. Thank you.
Bookmarks