Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying Negative %
I've got a cell that calculates a value as a %. Where the result is a negative value I'd like it to show the figure in Red. Can this be done ? Thanks, -- JohnHill ------------------------------------------------------------------------ JohnHill's Profile: http://www.excelforum.com/member.php...o&userid=25171 View this thread: http://www.excelforum.com/showthread...hreadid=536266 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying Negative %
If you set the field as Custom #,##0.00%;[Red]-#,##0.00% it will appear as such, but your calculation would need to allow for the different ( /100 ) figure shown. Hope this helps -- JohnHill Wrote: I've got a cell that calculates a value as a %. Where the result is a negative value I'd like it to show the figure in Red. Can this be done ? Thanks, -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=536266 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying Negative %
Hi John,
You can do that with conditional formatting. Go to FormatConditional formatting and set 'Cell value is' 'lower than' 0 and set your format to what you like. Whole cell Red or font red or perhaps border red. HTH Martin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add sequences of positive then negative numbers | Excel Discussion (Misc queries) | |||
irritating warning for negative data on log charts | Charts and Charting in Excel | |||
Negative Values Only | Excel Discussion (Misc queries) | |||
More problems displaying a negative time | Excel Discussion (Misc queries) | |||
How do I replace a negative number at the end of a formula with a. | Excel Discussion (Misc queries) |