Excel Pivot Table Conditional Format Show Text

wsnyder

New Member
Joined
Sep 23, 2018
Messages
29
Hi all,

I am trying to use conditional formatting to show a text value in a calculated field in a Pivot Table
If the value is 0, return a : Customer Number Format : [=0]"a";; This is then formatted as Marlett to get a nice looking Tick Mark.

But what if the value is 1? I would the cell in the Pivot Table to appear blank, but I keep getting open boxes.
What conditional formatting can I apply to get the cell to appear blank?

Thanks,
-w

Pivot Blank.png
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Watch MrExcel Video

Forum statistics

Threads
1,114,032
Messages
5,545,628
Members
410,696
Latest member
JTrehan
Top