Solved

how to set conditional formatting in a pivot table

Posted on 2015-01-20
6
39 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
Comment Utility
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
Comment Utility
I will give this a try - Thanks
0
 

Author Comment

by:vpopper
Comment Utility
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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Accepted Solution

by:
vpopper earned 0 total points
Comment Utility
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
Comment Utility
So how about awarding those points?
0
 

Author Closing Comment

by:vpopper
Comment Utility
Solved myself
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Excel macro help 8 40
LARGE INDEX formula 3 63
EXCEL: Random Select and Copy 10% of the Row 7 48
Button in Excel 5 49
HOW TO: Upload an ISO image to a VMware datastore for use with VMware vSphere Hypervisor 6.5 (ESXi 6.5) using the vSphere Host Client, and checking its MD5 checksum signature is correct.  It's a good idea to compare checksums, because many installat…
Scam emails are a huge burden for many businesses. Spotting one is not always easy. Follow our tips to identify if an email you receive is a scam.
Viewers will learn how to share Excel data with others from desktop Excel, as well as Excel Online via OneDrive, and embed an Excel file on a website.
Video by: Zack
Viewers will learn the basics of using Excel Tables, the benefits found with them, and some pitfalls.

762 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now