« Design Your Look: 5 More Ways to Customize the Way You Work | Main | Use Word to format professional e-mail messages »
Happy Thursday, everyone! Just a quick note to say that I'm off on vacation today and will be offline for 2 weeks.
Enjoy the rest of July! I've got some fun posts planned for as soon as I get back ... so please check in!
... if you send me e-mail or post a comment -- I will reply and your comment will appear as soon as I get back online :)
Have a good one...
Posted by Stephanie
TrackBack URL for this entry:
http://www.arouet.net/cgi-bin/mt/mt-tb.cgi/110
Thanks for signing in, . Now you can comment. (sign out)
(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)
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