I'm working on a very big data set of visitor numbers to a location. I wish to find a way to mark increase or decrease either by arrows or color to quickly analyse the entire data set. Usually I would be using graphs, but there are to many factors now so the graph is unreadable.
The result in this video is a good example of the result I want: https://www.youtube.com/watch?v=SFU5ZlHUdH0
The problem with that method is that my numbers are in total values, with no + or – sign used, and manually adding – isn't really an option in a set this big.
Is there any way to make color changes in a cell based on the cell above when to total value is lower or higher?
Best Answer
You can use conditional formatting using a formula. You apply the formatting (color etc.) based on the difference between the two cells. Say, you had data in cells
A1:A10
you would -A2:A10
(start in A2)=(A2-A1)<0
.The result should be that each cell is formatted
IF
the current cell decreases relative to the preceding cell.