very complicated conditional formating

[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

 

[Frank Kabel]

Hi
try the following formula
=COUNTA(1:1)=0