Skip to main content
Web Applications

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

4
  • 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. Commented Mar 6, 2017 at 16:30
  • 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. Commented Mar 6, 2017 at 16:39
  • 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. Commented Mar 6, 2017 at 18:41
  • See the updated answer. Commented Mar 6, 2017 at 19:28