Solved

how to set conditional formatting in a pivot table

Posted on 2015-01-20
6
53 Views
Last Modified: 2015-03-05
I set conditional formatting of a pivot table (red for neg value and green for poss value) but when I refresh the pivot, the formatting disappears.  What am I doing wrong?

Thanks
0
Comment
Question by:vpopper
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 2

Expert Comment

by:jkasavan
ID: 40560878
I find if I apply the conditional format to the entire column of the pivot table then the formatting stays persistent even after refreshing.
0
 

Author Comment

by:vpopper
ID: 40561936
I will give this a try - Thanks
0
 

Author Comment

by:vpopper
ID: 40564483
This does not work.  My Pivot table is being fed by an external data source (Access Database).  When I open my Excel file - and the data refreshed in my pivot table - and the conditional format seems to disappear (colored text changed back to black).

I opened the conditional formatting rules -they are still there:
Cell Value < 0 (Red Text)
Cell Value > 0 (Green Text)

But all the text is black.

Any ideas anyone???
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Accepted Solution

by:
vpopper earned 0 total points
ID: 40564511
Got it...had to edit the formatting rule to "All cells showing "XXX" values - under Apply Rule To:


Thanks
0
 
LVL 2

Expert Comment

by:jkasavan
ID: 40612859
So how about awarding those points?
0
 

Author Closing Comment

by:vpopper
ID: 40646491
Solved myself
0

Featured Post

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Excel - doing Sum inside Data Model 4 115
Vlookup nonexact IP address match 32 130
Modify to work without control shift enter 9 50
EXCEL file checking. 11 48
: Microsoft Office Collaborate for free and online versions of Microsoft  Word, Excel, Powerpoint, OneNote, Onedrive , Email, Calendar etc. In short we can say that Microsoft office is a suite of servers, applications and services developed by  Micr…
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
Viewers will learn how to customize the ribbon and quick access toolbar in Excel 2013.
Video by: Zack
Viewers will learn about various customizable options in Excel 2013.

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question