ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Conditional color formatting in a pivot - possible ? (https://www.excelbanter.com/excel-programming/398620-conditional-color-formatting-pivot-possible.html)

Romanoff

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



All times are GMT +1. The time now is 05:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com