Improve company productivity with a Business Account.Sign Up

x
?
Solved

how to set conditional formatting in a pivot table

Posted on 2015-01-20
6
Medium Priority
?
104 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
  • 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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
Viewers will learn how to create a PivotTable and make basic changes to it in Excel 2013.

606 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