Format cells negative numbers

[Alpacino]

How do I format cells do that if figures are -15 say it will show in red (15)
Thanks

 

[GDH]

Read up on conditional formatting, use the keystrokes Alt + O + D to bring up the conditional formatting menu or look in the home ribbon.

 

[jasonb75]

Read up on conditional formatting, use the keystrokes Alt + O + D to bring up the conditional formatting menu or look in the home ribbon.

If you can meet the requirement using conditional fomatting then I would love to know how it's done.

Try using a custom number format like one of

0;[Red](0)

0.00;[Red](0.00)

#,##0;[Red](#,##0)

or similar if needed to get the desired format.

 

[barry houdini]

In Excel 2007 and later versions you can set number formats via conditional formatting.......but unless you want the fill colour to change too (or some other formatting) then simple number formatting would be the best approach as Jason suggests