Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
"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. |
#8
|
|||
|
|||
"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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|