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

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

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