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!