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

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

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



DONPITO wrote:

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

Hi,

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

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

Good luck,


Roly


--
roly
------------------------------------------------------------------------
roly's Profile: http://www.excelforum.com/member.php...o&userid=24631
View this thread: http://www.excelforum.com/showthread...hreadid=401998