TO ASK A QUESTION: If you have a question or need help with Office, please feel free to use the 'Click to Contact' link at the bottom of this page. You'll get a form that you can use to email a question to me. (I had been getting a ton of spam when accepting direct emails, so only emails that use this form will get through to me.)
Please be sure to mention the version of Office you are using when you send your question.
I answer all e-mails that I receive via this form, as long as they are polite :)
Since disabling comments on this site, I'm actually hearing from more of you with questions ... so, as it seems people prefer to email rather than comment, I'm going to leave comments disabled. As always, you can ask me any Office-related questions you have. If the question is outside of my expertise, I'll try to direct you to where you can get an answer.
Comments
Enjoy your vacation Steph!
Posted by: Inbar | July 27, 2005 07:43 PM
Hi, today I watched your webcast for easy charts on excel, you mentioned that you can use formulas to change the color of a data label customizing it, 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.08]0%;[black]0%
but doesn't work
Can you help me?
Thank you
Yasser I Salinas
Tha actual formula i'm using is the following:
[red][>0.1]0%;[black]0%
Posted by: Yasser Ismael Salinas | July 28, 2005 07:06 PM
Thanks, Inbar :)
... and Hi, Yasser ... when you want to format worksheet data based on values, the easiest thing is to use Conditional Formatting. Go to office.microsoft.com and search for the topic "Highlight financial performance with conditional formatting" for detailed steps.
Best,
Stephanie
Posted by: Stephanie | August 3, 2005 10:59 AM