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