Converting DIV/NA error in Pivot table into white font

**paradise2sr** · 02-08-2018, 01:04 AM

Hi,

I have a lots of Div / NA error in Pivot table .I want a macro that will just make those into white font.Also the if any of the box contains only zero,it would also make light black.

Hoping a kind response in this regard.

**kersplash** · 02-08-2018, 01:12 AM

You can probably do this with conditional formatting, but wouldn't it be better to resolve the Div/NA in your source data? It's a visual alert that something is wrong and by hiding it you may not see a problem that needs fixing.

**xlnitwit** · 02-08-2018, 04:53 AM

You can specify what to display for error values in the pivot table options so you can hide any errors that way.

**paradise2sr** · 02-08-2018, 08:53 AM

Thanx all of you,If a macro would be there then it would ease me.Also plz let me know the steps for doing the same by conditional formatting.

**xlnitwit** · 02-08-2018, 09:36 AM

By way of example

Sub Hide_PT_Errors()
    With ActiveSheet.PivotTables(1)
        .ErrorString = ""
        .DisplayErrorString = True
    End With
End Sub

**paradise2sr** · 02-09-2018, 08:44 AM

I think it did not worked out in my Pivot table as I have two pivot table built in a single worksheet.

**xlnitwit** · 02-09-2018, 08:51 AM

Then you can loop

Sub Hide_PT_Errors()
   Dim pvt as pivottable
   for each pvt in ActiveSheet.PivotTables
    With pvt
        .ErrorString = ""
        .DisplayErrorString = True
    End With
   next pvt
End Sub

**paradise2sr** · 02-21-2018, 02:39 AM

Still it did not worked out.And thanx for kind efforts.

Converting DIV/NA error in Pivot table into white font

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Converting DIV/NA error in Pivot table into white font

Re: Converting DIV/NA error in Pivot table into white font

Re: Converting DIV/NA error in Pivot table into white font

Re: Converting DIV/NA error in Pivot table into white font

Re: Converting DIV/NA error in Pivot table into white font

Re: Converting DIV/NA error in Pivot table into white font

Re: Converting DIV/NA error in Pivot table into white font

Re: Converting DIV/NA error in Pivot table into white font

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to Detect White Font Color Anywhere in Workbook

[SOLVED] Red Cell but nbeed White font in loop

[SOLVED] Macro changing font color to white instead of gray

[SOLVED] VB code to change the font to white for selected range

Macro to add data labels and color font white in Active Tab for all charts?

[SOLVED] white font in certain cells

macro to white out (to change a font in selected cells)

Bookmarks

Bookmarks

Posting Permissions