Sheets: Format One Cell Based On another Cell’s Value

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)

Leave a Reply