Pivot Table
 

I want to format a pivot table in such that each of the blank cells in a
column can be formatted to be blank instead of the words (blank) in the cell.

try conditional formating

=AND(B11="(blank)") take foreground and background as white, you can see them as blank cells

suppose B11 contains (blank), then the conditional formatting shows you as real blank cell (empty)

all the best

Pivot Table
 

On May 12, 11:19*am, dwake wrote:
I want to format a pivot table in such that each of the blank cells in a
column can be formatted to be blank instead of the words (blank) in the cell.

Instead of blank, what about invisible?

Use a conditional formatting that changes values that equal (blank) to
a white font, the values will no longer appear in the worksheet,
unless highlighted of course.

HTH,
Reeza

Pivot Table
 

Hi

Click on the field and de-select Blank
--
Regards
Roger Govier

dwake wrote:
I want to format a pivot table in such that each of the blank cells in a
column can be formatted to be blank instead of the words (blank) in the cell.