Hi, so I have a spreadsheet where I would put in a dollar value on my first column.
My second column is a daily % change.
So, basically what I'm trying to do is on my 2nd column, if a % change from the previous days percent change is greater than 5%, the cell turns green.
If a % change from the previous days percent change is less than 5%, the cell turns red.
If neither, then there is no change.
So for example, my 2nd column will look like the following:
0.5%
3%
10%
7%
-2%
-5%
1%
So, 0.5% will be no change since its the start. 3% is no change since the change from 0.5% to 3% is 2.5% which is less than a 5% change.
The 10% is green since the change from 3% to 10% is greater than 5%.
The 7% is no change. The -2% is red since the change is greater than -5%.
-5% no change. 1% is green. and so forth..
I've tried using formula option in conditional formatting, but the outcome isn't the same. My formula is... =B2-B1>5% (then cell turns green).
=B2-B1<5% (then cell turns red)
Please help!
Bookmarks