Search code examples
google-sheetsgoogle-sheets-formula

How to find value of previous cell for conditional formation in google sheets

I'm trying to figure out a way to make it so that if the cell in the previous column is less than the cell then the cell will become highlighted green using conditional formatting.

For example if B1 is "100" and A1 is "50" then conditional formation will automatically make B1 highlighted green

I've tried doing

format cells if... Greater than

INDIRECT(ADDRESS(ROW(),COLUMN()-1))

but it doesn't seem to work

Solution

  • I've found a solution; If you do

    Format cells if... Custom formula is

    =INDIRECT(ADDRESS(ROW(),COLUMN()))>INDIRECT(ADDRESS(ROW(),COLUMN()-1))

    Then it will work for any range which you input

    Example Image