Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

how to set conditional formatting in a pivot table

Posted on 2015-01-20
6
Medium Priority
?
92 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: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
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 various types of data validation for different data types in Excel 2013.

571 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