Hi all.
I was hoping for a little help as I am trying to set up conditional formatting so highlighting applied my range (H2:Ox) where x is the last row with content in column H.
Some googling led me to the following:
Defined name LastRw = MATCH(9.9E+307,$A:$A).
As such I think my range is =INDIRECT("$H$2:"&("$H"&"$"&(ROW()=LastRw)))
My issue is I have no idea how I would go around setting this up so that every row is highlighted, not just the last one. If it helps the formula for highlighting the last row is =ROW()=LastRw and that certainly works.
Any help you could give me would be great
Thanks
Ben