6 sets of data compared

The file is attached. I need column B compared to I,P,W,AD, and AK. To see if the value when up or down or stayed the same. I need the same for I compared to B,P,W,AD, and AK. P:B,I,AD, and AK, W: B,P,I,AD, AK, and AD: B.I,P,W,AK and AK: B, I, P, AD, AK.



The file is attached below. Thank you so much who ever helps me. If you know how could you also color code it so it's green if the value goes up and black if the same and red if it goes down. Thank you so much.

Is this what you are asking?

B compared to I,P,W,AD, and AK.
To see if the value when up or down or stayed the same.
I need the same for
I compared to B,P,W,AD, and AK.
P compared to B,I,W,AD, and AK,
W compared to B,P,I,AD, AK,
AD compared to B,I,P,W,AK
AK compared to B, I, P, AD, AK.

green if the value goes up
black if the value is the same
red if the value it goes down

In the first instance if I>B and P<B what colour does B become?

Sorry, I can't follow the logic in this

Can you mock up a sheet showing what result you expect?

Yea that's what I'm asking, The color would depend on what value is being compared to. So If B was being compared to I,P,W,AD and AK. The color should be based on if the value went up or down from B. If It was being compared to I the color would depend if the value went up or down from I. I hope that makes sense.