I have a pivot table with conditional formatting set up based on the value of the cell. Additionally I have the actual numbers (value of the cell) removed (custom cell format) so that just the color itself shows; however, I have some cells that have the #DIV/0! error message showing. I've been able to make the color happen, but can't get the "value" to disappear.  Any ideas?

Hi,

I can not understand the issue very well, did you mean that the value in the Pivot table show #DIV/0! instead of the actual value?