Change the colour of numbers in a cell if the number is negative
 

In excell is it possible to change the colour of a number in a cell for
example if it goes negative?

Change the colour of numbers in a cell if the number is negative
 

Look at FormatConditional Formatting and the available Help.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"bryno" wrote in message ...
| In excell is it possible to change the colour of a number in a cell for
| example if it goes negative?

Change the colour of numbers in a cell if the number is negative
 

If you look at Format/ Cells/ Number/ Custom, you will see formats like
#,##0;[Red]-#,##0 and you can change them to suit your requirements.
--
David Biddulph

"bryno" wrote in message
...
In excell is it possible to change the colour of a number in a cell for
example if it goes negative?

Change the colour of numbers in a cell if the number is negative
 

FormatCellsNUmberNumberNegative Numbers.

Choose whatever option you wish.


Gord Dibben MS Excel MVP

On Wed, 5 Mar 2008 12:35:03 -0800, bryno
wrote:

In excell is it possible to change the colour of a number in a cell for
example if it goes negative?