Hi, I have an spreadsheet with about 15 columns and 300 rows (and growing). I want to setup a conditional format that when 1 cell has a certain value, the entire row changes color. Any help would be appreciated! Thanks
OK, try this:
set the conditional format for all rows to:
This OFFSET function looks up a cell which is a specified number of columns and a specified number of rows away from cell A1.
As it stands this formula will reference the cell in column B for each row. Changing the '1' that I have highlighted will change the column referenced (eg.
=(OFFSET($A$1,ROW()-1,2)="YES") would reference column C
=(OFFSET($A$1,ROW()-1,3)="YES") would reference column D