Custom number formats - Selective cases
Hi, today I watched a webcast for easy charts on excel, in there it was
mentioned that you can use formulas to change the color of a data label
customizing the numbers, my question is: How can I use it to define for a
section? (I need to get red colored for values upper than 10%, yellow for
values between 10 and 8%, and normal for below) I tryied based on my
experince to use the following formulas:
[red][0.1]0%;[yellow][<0.1 and 0.08]0%;[black]0%
but doesn't work
Tha actual formula i'm using is the following:
[red][0.1]0%;[black]0%
I don't want to use macros, this is just to learn the way to do it different.
Thank you.
|