I want to colour a cell C5 in Google sheets red, if it is greater than the cell B5 before it. Can I do this for the whole sheet, using conditional formatting?
To be clearer: I want to do this for every column, so e.g. make C7 red if it's greater than B7, make E5 red if it's greater than D5, etc.
use formula on range B5:B
B5:B
=C5>B5
2.1m questions
2.1m answers
60 comments
57.0k users