=IF(A1<0,(B1-A1)/A1,NA())


--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jana" wrote in message
...
Thank you soooo much.

One more question though, the formula works unless 1 of the numbers is 0,
then I get a "#DIV/0!" in the cell.

"Gary''s Student" wrote:

If the first value is in A1 and the second is in B1 then =(B1-A1)/A1
(formatted as a %) is the percent difference.

A positive value will mean a percent increase and a negative value will
be a
percent decrease
--
Gary''s Student


"Jana" wrote:

I am trying to show the percentage difference between two numbers and
also
show the overage in red....Help!