PC Review


Reply
Thread Tools Rate Thread

Conditional color formatting in a pivot - possible ?

 
 
Romanoff
Guest
Posts: n/a
 
      3rd Oct 2007
Hello all,

I've got a pivot-question.
Is it possible to color some numbers in a pivot which achieve a
certain criteria ?

Example1: All Numbers in the data column Amount1 that are higher than
100 should be marked red.

or

Example2: if the sum of certain numbers in a data column is less than
1000 than mark them all blue....

Well, in an excel table, there is the function conditional
formatting.... is there also a possibility with a pivot table ?
If yes, is there any examples or some VBA code,
if no, what are the reasons and limitations ?


Thanks for the help !

Regards,
Roman

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Font Color Conditional Formatting/Color Scaling Ryan Microsoft Excel Worksheet Functions 0 4th Mar 2010 06:03 PM
Conditional Formatting in Pivot Based on other values in pivot. XL =?Utf-8?B?TWF0cyBN?= Microsoft Excel Misc 0 7th Nov 2007 10:36 AM
Pivot Conditional Formatting =?Utf-8?B?RG9uaWNh?= Microsoft Excel Programming 4 4th May 2007 10:01 PM
Conditional color formatting entries have wild color. =?Utf-8?B?Sm9obiBHZXllcg==?= Microsoft Excel Misc 0 24th Feb 2006 06:11 PM
Pivot table -conditional formatting (color) Nuralain Microsoft Excel Programming 0 21st Nov 2003 09:48 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:31 AM.