close
Can a cell that is formated for percentage be red if the percentage is
negativeHi Steve
1) with custom format 0%;[Red]0%
OR
2) using Format |Condition Format; Formula is A1lt;0 ... format font or
background to red
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
quot;SteveWquot; gt; wrote in message
...
gt; Can a cell that is formated for percentage be red if the percentage is
gt; negative
gt;
Yeah, just set a custom format of
0%;[Red]0%;0%
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
quot;SteveWquot; gt; wrote in message
...
gt; Can a cell that is formated for percentage be red if the percentage is
gt; negative
gt;
全站熱搜
留言列表
