LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Dragospeed
 
Posts: n/a
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom Formats Amanda Cooper Excel Discussion (Misc queries) 1 May 11th 05 06:04 PM
Custom Formats Amanda Cooper Excel Discussion (Misc queries) 1 May 11th 05 05:56 PM
number formats that allow you to format the appearance of negativ. jassmon Charts and Charting in Excel 1 January 15th 05 09:04 AM
Nested IF limit or Open parentheses limit Fred Excel Discussion (Misc queries) 5 December 23rd 04 03:34 PM
How to format a number in Indian style in Excel? Victor_alb Excel Discussion (Misc queries) 2 December 21st 04 04:21 AM


All times are GMT +1. The time now is 02:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"