Dear All,
PFA the excel sheet showing the output format.
Scenario 1 : you can see that the competitor B’s sales is 10 and my company's sales has decreased to 8 compared to last month.
Hence B’s position/rank has been upgraded to 1st and my company's position / rank has been degraded to 2nd.
In this scenario, the B’s position background colour should be changed to “red”.
Scenario 2 : my company’s sales is 9 & B’s Sales is 7 in month of October.
my company’s sales has increased to 10 as well as B’s sales has increased to 9 in the month of November.
Still the position of my company & B does not change.
Hence the background colour of B should not be changed.
The background colour of the competitor changes until and unless the rank / position upgraded or degrades.
Request all to help me if possible.
Thanks in advance.
.png "bbi_mba_76"){kind=avatar}
