Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Help...I have created a spread sheet and I need to change the font color to
red on all the negarive numbers. I tried searching for but it doesnt' work. Help ahain..thx |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Select some of the cells that you wish to format this way, and from the Menu
Bar, <Format <Cells <Number tab, And click on "Custom", Scroll down and you'll see several formats with RED in them. Select one, and using that as a start sample, you should be able to get something you like. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Regards" wrote in message ... Help...I have created a spread sheet and I need to change the font color to red on all the negarive numbers. I tried searching for but it doesnt' work. Help ahain..thx |
#3
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Did you look under FormatCellsNumberNumber "Negative Numbers"?
Gord Dibben MS Excel MVP On Thu, 18 Oct 2007 17:40:01 -0700, Regards wrote: Help...I have created a spread sheet and I need to change the font color to red on all the negarive numbers. I tried searching for but it doesnt' work. Help ahain..thx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Font Colours / negative numbers | Excel Discussion (Misc queries) | |||
How to make the cell or font color red if the number is negative? | Excel Worksheet Functions | |||
can the negative numbers in an IF statement be in a diff color th. | Excel Worksheet Functions | |||
can the negative numbers in an IF statement be in a diff color th. | Excel Worksheet Functions | |||
How do I display negative numbers in a differnt color font? | Excel Discussion (Misc queries) |