how do I order a cel to be in red color if number is negative

[Guest]

I AM USING OFFICE 2003, AND IN MY WORK SHET SOMETIMES I HAVE NEGATIVE
NUMBERS, HOW CAN I ORDER A COLUM TO TURN A CEL WITH A NEGATIVE NUMBER ON IT
RED IN COLOR??????

 

[Dave Peterson]

You could use Format|conditional formatting (it's pretty straightforward when
you see the dialog).

or you could use a custom format:

#,##0_);[Red](#,##0)
or
#,##0;[Red]-#,##0

 

[roly]

Hi,

You can use conditional formatting to make figures is less than zer
red.

Select the range you wish to format, the Format menu and Conditiona
Formatting. Click the second combo box (that says between), and selec
Less Than and type 0 in the next box. Select the Format button an
select Red in the Colour list.

Good luck,


Rol