help with this
 

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

Hi Chris
Highlight the column in question
Have a look at Format / Conditional Formatting
In the first box, select Cell value is
Inthe second box, select is lees than
and the last box, 0
Then format as required and click OK

HTH
Michael Mitchelson


"Chris" wrote:

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

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

Thanks pals!

"Chris" wrote:

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

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

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

"Michael" wrote in message

Hi Chris
Highlight the column in question
Have a look at Format / Conditional Formatting

Why? There's a standard custom format for negative numbers to be red.

"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

Select the column, go to Format Cells-Custom Format and scroll down untill
you see something like "#,##0:[red]-#,##0"

HTH