Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Color negative numbers in a big sheet in 2003
Hi Is it possible in any way to mark a big sheet from A1 to AD360 and make excel 2003 make all the negative numbers/cells with red text?? I can in 2007, but not in 2003.. Have a nice day :) Just a regular user |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Color negative numbers in a big sheet in 2003
Format Cells Number select red number
"Rockbear" wrote: Hi Is it possible in any way to mark a big sheet from A1 to AD360 and make excel 2003 make all the negative numbers/cells with red text?? I can in 2007, but not in 2003.. Have a nice day :) Just a regular user |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Color negative numbers in a big sheet in 2003
You could use Format|conditional formatting
Select A1:Ad360 With A1 the activecell, Format|conditional formatting Cell value is: Less than 0 Or you could use: Select the range Format|cells|number tab|number category Choose from the optional negative number formats. Or you could use a custom number format select the range format|cells|number tab|Custom category 0.00;[Red]0.00;0;@ It's positive;negative;0;text You can change the number of decimals in each section. Rockbear wrote: Hi Is it possible in any way to mark a big sheet from A1 to AD360 and make excel 2003 make all the negative numbers/cells with red text?? I can in 2007, but not in 2003.. Have a nice day :) Just a regular user -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Font color for negative numbers | New Users to Excel | |||
Font color for negative numbers | New Users to Excel | |||
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) |