Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting - color | Excel Discussion (Misc queries) | |||
conditional formatting for tab color | Excel Worksheet Functions | |||
Color Conditional Formatting | Excel Worksheet Functions | |||
Conditional color formatting entries have wild color. | Excel Discussion (Misc queries) | |||
Pivot table -conditional formatting (color) | Excel Programming |