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
|