| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
format number custom want some values in red
I think Mike may have been confused. Try changing his custom formatting to
[Red][<1]0%;[Black]0% -- David Biddulph "learningaccess" wrote in message ... Hi Mike, It almost worked. But the custom formula changes my numbers. It turns all of the numbers red and reverts back to decimal form. For example 125% becomes 1.25, 65% becomes .65. I'd really like 125% in black and 65% in red. Thanks very much for your help. Is there anything else you think I could try? PLs let me know. Thanks, Chris -- Thanks! "Mike H" wrote: A conditional format may be neater but if you want a Custom number format try this:- [Red][<100]General"%";[Black]General"%" Mike "learningaccess" wrote: Hi. I have a spreadsheet showing percents. Some are over 100%, some are less than 100%. Say for example, 125% and 65%. Can you please tell me how I can make a custom number format to make the percentages less than 100% show up as red? So 125% would remain black but 65% would turn red, for example. This is a bit urgent. Your help is greatly appreciated. -- Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| custom format for boolean values | Excel Discussion (Misc queries) | |||
| Moving custom number format to NUMBER | Setting up and Configuration of Excel | |||
| how do I add phone number format as a permanent custom format? | Excel Discussion (Misc queries) | |||
| Format a cell with a custom number format | Excel Worksheet Functions | |||
| Custom number format always defaults last number to 0. | Excel Discussion (Misc queries) | |||
![David Biddulph[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
