Forum Discussion

Zheng Ou Berg's avatar
Zheng Ou Berg
Copper Contributor
May 01, 2018

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

Resources