detriez
Board Regular
- Joined
- Sep 13, 2011
- Messages
- 193
- Office Version
- 365
- Platform
- Windows
I'm trying to create a multiple column dynamic named range by referencing multiple cells for the OFFSET
The end result of what I'm trying to do is format cell backgrounds where at least one cell in a row between Columns D & M have a value
My plan is to first create a a dynamic named range and conditional format blank cells when they are empty
Not sure if my approach is correct
This doesn't get me there.
The end result of what I'm trying to do is format cell backgrounds where at least one cell in a row between Columns D & M have a value
My plan is to first create a a dynamic named range and conditional format blank cells when they are empty
Not sure if my approach is correct
This doesn't get me there.
Excel Formula:
=OFFSET(Template!$D$2:$M$2,0,0,COUNTA(Template!$D:$M),1)