MS Excel - nagative values in colour

[Goofy]

I'm sure I used to be ble to do this, but I cannot work out how to show negative values in colour. Help please!

[TTG]

Select Format, then conditional formatting.

[ChuckFickens]

Either right click on the cell and select format cells and change the cell to be a number cell and negative values will be in red

or if you want to select another colour then use conditional formatting on the format menu.

[Ankou]

click on format on the toolbar, then cells, then select 'number' on the pop up tab.
select custom from the list on the left, then the option should be there.

in our field we normally do a negative in red with brackets around it.

[Goofy]

thanks so much all of you. It looks much better now!