You are right that it only takes one condition, the other was personal
preference, I always try to do as much as possible with the regular
formatting, that way you can create up to 6 conditions as shown here


http://www.mcgimpsey.com/excel/conditional6.html

I should have chosen a different phrase though

--
Regards,

Peo Sjoblom

(No private emails please)


"Michael" wrote in message
...
Hi Peo
You've got me intrigued !!
I don't see why the OP needs two conditional formats for his problem.
He only needs one for negative no's and the normal format for the
rest....I
think.
Also, why is conditional format "not recommended in this case"

If I don't ask, I don't learn !!

Regards
Michael Mitchelson


"Peo Sjoblom" wrote:

Custom format for instance

General;[Red]General

or if you want decimals

0.00;[Red]0.00

you can also get it through conditional formatting using 2 conditions but
that
is not to recommend in this case

--
Regards,

Peo Sjoblom

(No private emails please)


"Chris" wrote in message
...
Hi,
How do set the cell font color to red if the value is a minus ("-")
amount
like -2 and if a positive like 2, then it remains black. I want this
formula
to be on all rows on a specific column.

Thanks