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