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

B

bryno

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

Niek Otten

Look at Format>Conditional Formatting and the available Help.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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

David Biddulph

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

Gord Dibben

Format>Cells>NUmber>Number>Negative Numbers.

Choose whatever option you wish.


Gord Dibben MS Excel MVP
 

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
Linking Equations to Highlights 2
Change positive to negative number 4
Divide two cells and if the number is negative display is as zero 2
Change the colour 1
Make a Yes/no cell using a single click 6
Sum if cell = grey 4
colour cells, same numbers different worksheets 1

Top