very complicated conditional formating

L

lachlanmullen

I am trying to conditionally format a row if the row is blank.

Here's what i'm trying now:


Code
-------------------
=SUM($&RIGHT((ADDRESS(ROW(),COLUMN(),4),(LEN(ADDRESS(ROW(),COLUMN(),4))&:&$&RIGHT((ADDRESS(ROW(),COLUMN(),4),(LEN(ADDRESS(ROW(),COLUMN(),4))
-------------------


My goal is to have the net result read "=sum($R:$R)" where R is th
active row number for the conditional format.

All i'm getting is an error message.

Thanks, please advise
 
Top