I was wanting to know how I can add some conditional formatting to the below grid which shows weekly ranks for sales people. I havent been able to figure out how to do this, as the conditional formating only appears to allow for data across the whole table (>25%, between, <25% etc.)
As you can see, some of the sales people have moved up and down across the various weeks. Ideally I would like to show an up arrow (green) when they improve rank, sideways (orange) arrow when they stay the same, and a down (red) arrow when they lose a rank week on week.
Any guidance or help would be appreciated.