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: www.excelforum.com/member.php...oamp;userid=25171
View this thread: www.excelforum.com/showthread...hreadid=536266
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:
gt; I've got a cell that calculates a value as a %. Where the result is a
gt; negative value I'd like it to show the figure in Red. Can this be done
gt; ?
gt;
gt; Thanks,--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=536266Hi John,
You can do that with conditional formatting.
Go to Formatgt;Conditional 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
- Oct 18 Sat 2008 20:47
Displaying Negative %
close
全站熱搜
留言列表
發表留言