LinkBack URL
About LinkBacks
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.
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.
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.
You can specify what to display for error values in the pivot table options so you can hide any errors that way.
Don
Please remember to mark your thread 'Solved' when appropriate.
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.
By way of example
Please Login or Register to view this content.
I think it did not worked out in my Pivot table as I have two pivot table built in a single worksheet.
Then you can loop
Please Login or Register to view this content.
Still it did not worked out.And thanx for kind efforts.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks