| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I display negative numbers in a differnt color font?
-- Thanks. Steve |
|
#2
|
|||
|
|||
|
set a custom format of say
#,##0.00;[Red](#,##0.00 -- HTH RP (remove nothere from the email address if mailing direct) "Steve" wrote in message ... -- Thanks. Steve |
|
#3
|
|||
|
|||
|
Hi
goto 'Format - Cells', choose 'Number' and choose one coloured option -- Regards Frank Kabel Frankfurt, Germany "Steve" schrieb im Newsbeitrag ... -- Thanks. Steve |
|
#4
|
|||
|
|||
|
Select the cells you want this to happen to.
Format | Cells, Pick either Number or Currency. Then, you can set one of the red options. If you want a color other than red, try a Custom Format. Something like: #,##0_);[Blue](#,##0) would work. You can experiment a little to figure out what colors are available to you. tj "Steve" wrote: -- Thanks. Steve |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| Display negative data points differently. | Charts and Charting in Excel | |||
| Negative Numbers | Excel Discussion (Misc queries) | |||
Linear Mode
