Color negative numbers in a big sheet in 2003

  • Thread starter Thread starter Rockbear
  • Start date Start date
R

Rockbear

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Red cell for negative numbers in Excel 1
Negative numbers 5
Divide two cells and if the number is negative display is as zero 2
Negative Numbers in a Pivot Table 1
Negative numbers 4
Coloring cells 8
How To Detect A Negative Number In A Cell 7
Excel 2003 - negative following the number 2

Back
Top