S
songmu
I use the pivot table to display data. and a column need to be formated by
different color.
the column is defined:
(-10%,10%) the font color is RED color; (-20%,-10%] U [10~20%) the
font color is BLACK color; (-¡Þ ,-20%] U [20%,¡Þ) the font color is YELLOW
color. I used this, but didn't work
"[YELLOW][>=0.2]#0.00%;[BLACK][>=0.1]#0.00%;[RED][>-0.1]#0.00%;[BLACK][>-0.2
]#0.00%;[YELLOW][<=-0.2]#0.00%"
how do I use the number format?
thanks for your help!
different color.
the column is defined:
(-10%,10%) the font color is RED color; (-20%,-10%] U [10~20%) the
font color is BLACK color; (-¡Þ ,-20%] U [20%,¡Þ) the font color is YELLOW
color. I used this, but didn't work
"[YELLOW][>=0.2]#0.00%;[BLACK][>=0.1]#0.00%;[RED][>-0.1]#0.00%;[BLACK][>-0.2
]#0.00%;[YELLOW][<=-0.2]#0.00%"
how do I use the number format?
thanks for your help!