Conditional Formatting based on adjacent cells

[Asator]

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?

 

[Asator]

>> swinglow:

I like the idea, but it didn't work

>> Norie:
Yeah, I deleted the contents, and righ clicked to hit "clear contents"


Looks like it works for VoG. What version are you using?

Edit: Just tried it on a completely blank workbook. Still doesn't work. Strange.