color

U

unregistered

I'm makeing a spreadsheet dealing with money and I forgot how to make it
so that if a number turns up to be negative it becomes red. Can someone
remind me?
 
N

Norman Harker

Hi unregistered!

Use:

Format > Cells > Currency
Select from the negative options.

You can make changes to the default use of - or () and positioning etc
of $ symbol using:

Start > Control Panel > Regional Settings > Currency Tab


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top