Solved

how to set conditional formatting in a pivot table

Posted on 2015-01-20
6
54 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: 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.

 

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: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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

: 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
Video by: Zack
Viewers will learn about using Excel in a browser with Excel Online.
Viewers will learn the basics of using filtering and sorting in Excel 2013.

705 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