formatting - How do I conditionally change the colour of a cell in Google sheets, based on the cell before?

Question

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.

question from:https://stackoverflow.com/questions/65859209/how-do-i-conditionally-change-the-colour-of-a-cell-in-google-sheets-based-on-th

Answer 1

use formula on range B5:B

=C5>B5