Assuming cell A1 has your 1st value and B1 your 2nd.

Cell C1 should be =A1/B1

Then format that cell to be a % and it'll work.

For the average of the 2 number cell D1 should be =(A1+B1)/2

Then fomat font to br red.

HTH.

"Jana" wrote:

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