M
Mark
Does anyone know how to stop percentages changing to red when negative?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
Use a format like 0.00%
Regards,
Peo Sjoblom
Regards,
Peo Sjoblom
D
David McRitchie
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
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
M
Mark
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?
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?
H
Harlan Grove
Mark said: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?
J
JulieD
Hi Mark
also check that some bright spark hasn't put conditional formatting on the
cell - format / conditional formatting
Cheers
JulieD
also check that some bright spark hasn't put conditional formatting on the
cell - format / conditional formatting
Cheers
JulieD
M
Mark
Thats it! Conditional format set. Didn't occur to me.
Thanks Julie and everyone else for your help.
Thanks Julie and everyone else for your help.
JulieD said:Hi Mark
also check that some bright spark hasn't put conditional formatting on the
cell - format / conditional formatting
Cheers
JulieD
Mark said: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?
J
JulieD
you're welcome
Mark said:Thats it! Conditional format set. Didn't occur to me.
Thanks Julie and everyone else for your help.
JulieD said:Hi Mark
also check that some bright spark hasn't put conditional formatting on
the cell - format / conditional formatting
Cheers
JulieD
Mark said: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?