Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Stop % in red
Does anyone know how to stop percentages changing to red when negative?
|
#2
|
|||
|
|||
Use a format like 0.00%
Regards, Peo Sjoblom "Mark" wrote: Does anyone know how to stop percentages changing to red when negative? |
#3
|
|||
|
|||
Hi Mark,
If you look at the format under Format, cells, custom it should be apparent where the Red comes from. http://www.mvps.org/dmcritchie/excel/formula.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Peo Sjoblom" wrote in message ... Use a format like 0.00% Regards, Peo Sjoblom "Mark" wrote: Does anyone know how to stop percentages changing to red when negative? |
#4
|
|||
|
|||
Its weird - I can see exactly how it should work and if I use the custom
format [Black]0%;[Black]-0%;[Black]0% in different worksheet it works fine. But even if I copy and paste-special this format to my existing worksheet it still refuses to change from red when the % is negative. I'm completely stumped. Any ideas? |
#5
|
|||
|
|||
"Mark" wrote...
Its weird - I can see exactly how it should work and if I use the custom format [Black]0%;[Black]-0%;[Black]0% in different worksheet it works fine. But even if I copy and paste-special this format to my existing worksheet it still refuses to change from red when the % is negative. I'm completely stumped. Any ideas? What's the number format of the cell that's displaying the negative percentage in red? What the cell's font color? Has one of your friendly colleagues changed the 'black' color to red in Tools Options Color? |
#6
|
|||
|
|||
Hi Mark
also check that some bright spark hasn't put conditional formatting on the cell - format / conditional formatting Cheers JulieD "Mark" wrote in message ... Its weird - I can see exactly how it should work and if I use the custom format [Black]0%;[Black]-0%;[Black]0% in different worksheet it works fine. But even if I copy and paste-special this format to my existing worksheet it still refuses to change from red when the % is negative. I'm completely stumped. Any ideas? |
#7
|
|||
|
|||
Thats it! Conditional format set. Didn't occur to me.
Thanks Julie and everyone else for your help. "JulieD" wrote in message ... Hi Mark also check that some bright spark hasn't put conditional formatting on the cell - format / conditional formatting Cheers JulieD "Mark" wrote in message ... Its weird - I can see exactly how it should work and if I use the custom format [Black]0%;[Black]-0%;[Black]0% in different worksheet it works fine. But even if I copy and paste-special this format to my existing worksheet it still refuses to change from red when the % is negative. I'm completely stumped. Any ideas? |
#8
|
|||
|
|||
you're welcome
"Mark" wrote in message ... Thats it! Conditional format set. Didn't occur to me. Thanks Julie and everyone else for your help. "JulieD" wrote in message ... Hi Mark also check that some bright spark hasn't put conditional formatting on the cell - format / conditional formatting Cheers JulieD "Mark" wrote in message ... Its weird - I can see exactly how it should work and if I use the custom format [Black]0%;[Black]-0%;[Black]0% in different worksheet it works fine. But even if I copy and paste-special this format to my existing worksheet it still refuses to change from red when the % is negative. I'm completely stumped. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what is the keys to stop recording, i cant press it when making a. | Excel Discussion (Misc queries) | |||
Can't stop time duration [hh]:mm:ss converting to time of day | Excel Discussion (Misc queries) | |||
How do I stop the autopaste function in Excel? | Excel Worksheet Functions | |||
How do I stop other circles in other cells to stop selecting? | Excel Worksheet Functions | |||
How do I stop other circles in other boxes to stop selecting? | Excel Worksheet Functions |