Forum Discussion
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 ...
Hi 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.