Let’s say that you wish to give a cell a different color if the cell on the left has a value:
=IF(INDIRECT(REGEXEXTRACT(ADDRESS(ROW(), COLUMN()-1), “[A-Z]+”)&ROW()) = 1, true, 0)
Let’s say that you wish to give a cell a different color if the cell on the left has a value:
=IF(INDIRECT(REGEXEXTRACT(ADDRESS(ROW(), COLUMN()-1), “[A-Z]+”)&ROW()) = 1, true, 0)