How to show a change in a value when choosing from a drop down list

Hey everyone

I have a spreadsheet that provides the user with many options in forms of multiple drop down menu. When a selection is made from the menu, values relating to that choice are displayed.

So in other words...

User chooses options A, A, A from 3 separate drop down menus where A = 5 and B = 1

What I would like to do is after this is done, when the user chooses say A, B, A, the spreadsheet would flag the B value as having decreased from 5 to 1. So in an ideal world I would have a cell next to the one with B in it saying - 4. Then if the user wishes to have B even with the drop of 4, then they could choose it

So i suppose it is like what if analysis, but with the many hundreds of permutations that my spreadsheet would require.

My knowledge of excel is good and I have a certain level of coding experience but none in macros or vba!

Thanks for your help

EDIT: I thought of a suitable example to make myself clearer. Consider a video game character page. When you increase your level it shows how some values went up and how some went down from what they were originally. My goal is to make something equivalent to that