Just like OP I was trying to get row-based conditional formatting going. Using OFFSET worked for me. Thanks @ttaaoossuu. The naysayers may not like it but it seems to be the only workaround that actually works.

Additionally, note that conditional formatting does not allow boolean indicators like AND, but easily got around that by creating hidden columns to do the hard work of combining conditions.