Timeline for Google sheets conditional formatting relative to another cell in the same column
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 6, 2017 at 19:28 | comment | added | Karl_S | See the updated answer. | |
| Mar 6, 2017 at 19:28 | history | edited | Karl_S | CC BY-SA 3.0 |
added 351 characters in body
|
| Mar 6, 2017 at 18:41 | comment | added | AnakhaS | I think there's a misunderstanding. Wat I need is the cell to turn green if its value is ANY value higher than the value in the previous cell and red if it's ANY value lower than the value in the previous cell. That's not the case in your image. | |
| Mar 6, 2017 at 16:41 | history | edited | Karl_S | CC BY-SA 3.0 |
Added image to go with comments item
|
| Mar 6, 2017 at 16:39 | comment | added | Karl_S | Then make a minor change to the values. Apply to range B3:B and change the custom formula to =B3<B4 and =B3>B4 It is working in my test sheet. I added an image to my post showing the changes. | |
| Mar 6, 2017 at 16:30 | comment | added | AnakhaS | I'm afraid that doesn't work. Firstly, it doesn't take into account that there are 2 header rows and secondly, it doesn't seem to look at the right cells at it sometimes colors red cells that are smaller than the previous one, and sometimes those that are bigger than the previous one. | |
| Jan 24, 2017 at 13:18 | history | answered | Karl_S | CC BY-SA 3.0 |