Forum Discussion
Zheng Ou Berg
May 01, 2018Copper Contributor
Conditional formatting
How do I mark a row green/red/black automatically when it's higher/lower/equal than an other row? So for example:
1 2 3 4 5 (0-measurement)
3 4 3 5 2 (Want to change this into: 3 green-3 green-3 black-5 green- 2 red)
I uploaded a picture of results I have to compare, it would be fine if there's an easier way than manually giving those results a colour.
I hope to hear from you.
Thanks!
1 Reply
- SergeiBaklanDiamond ContributorHi Zheng, Starting from second row you may apply the rule =A2<OFFSET(A2,-1,0) for the red colour; and similar rule for the green. Please see attached.