Comparison between two numbers

[slam]

I have two columns that contain positions 1st through 16th, (A2:A17 and D2:D17) and need to do a comparison between the two to show the difference in column I. In addition, I would like the cell shaded depending on whether there’s a negative, positive or neutral result.

A couple of examples of what I need:

A2 contains 1st, and D2 contains 10th, I would want I2 to display +9 and be shaded green
A8 contains 7th, and D8 contains 2nd, I would want I8 to display -5 and shaded green

If the two values match (16th and 16th), I would want a 0 displayed and the cell shaded yellow.

Any help would be greatly appreciated.

Thanks

 

[slam]

It's probably also worth me adding that column D is the result of the following formula:

=IF(ISBLANK(E2),"",RANK(E2,$E$2:$E$17,1)&LOOKUP(RANK(E2,$E$2:$E$17,1),{1,2,3,4},{"st","nd","rd","th"}))

Column A is just text.

Thanks

 

[slam]

Is anyone able to help with this?

Thanks