Format-Can a cell that is formated for percentage be red if the percentage is negativ

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

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" <SteveW@discussions.microsoft.com> wrote in message
news:EAFE4651-1BBA-46E1-9A0B-B28EEB9CBB65@microsoft.com...
> Can a cell that is formated for percentage be red if the percentage is
> negative
>

Yeah, just set a custom format of

0%;[Red]0%;0%

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"SteveW" <SteveW@discussions.microsoft.com> wrote in message
news:EAFE4651-1BBA-46E1-9A0B-B28EEB9CBB65@microsoft.com...
> Can a cell that is formated for percentage be red if the percentage is
> negative
>