I am desperately looking for a way that allows me to conditionally format a cell depending on whether its value has increased, decreased or stayed the same.
However, I don't want to compare its value with the value of other or adjacent cells.
Rather, what I would like to do is that Excel applies an upside arrow in the case that the value of the cell increased, and upside arrow if the value of the cell decreased and an arrow showing to the right if the value stayed the same.
Here is an example to illustrate what I mean:
Let's say the value of a cell is 5 and once this becomes 6 or higher, it should get an upside arrow.
Is there a way to get this done? Thanks!
Excel does not keep a history of what a cell's value was in the past. Hence it cannot detect whether the current value is an increase or a decrease compared to the previous value of the cell. There is no conditional format and no logic that can look at just the cell to determine if the value has gone up or down.
In order to achieve such formatting, the previous cell value would have to be stored somewhere.
I suggest you take a step back and describe the bigger picture before focusing on a specific technique.
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments