View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Romanoff Romanoff is offline
external usenet poster
 
Posts: 5
Default Conditional color formatting in a pivot - possible ?

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