I'm trying to apply a conditional formatting based on the value, not of the cell itself, but of an adjacent cell.
The formula I have in my conditional format (to see if the cell is blank):
=IF(OFFSET(C26,0,1)="",TRUE)
But it doesn't seem to work. Any ideas?
The formula I have in my conditional format (to see if the cell is blank):
=IF(OFFSET(C26,0,1)="",TRUE)
But it doesn't seem to work. Any ideas?