Format
 

Can a cell that is formated for percentage be red if the percentage is
negative

Format
 

Hi Steve
1) with custom format 0%;[Red]0%
OR
2) using Format |Condition Format; Formula is A1<0 ... format font or
background to red
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"SteveW" wrote in message
...
Can a cell that is formated for percentage be red if the percentage is
negative

Format
 

Yeah, just set a custom format of

0%;[Red]0%;0%

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"SteveW" wrote in message
...
Can a cell that is formated for percentage be red if the percentage is
negative