close

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

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()