Dynamic Named Range using more than one cell reference

[detriez]

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.

=OFFSET(Template!$D$2:$M$2,0,0,COUNTA(Template!$D:$M),1)

 

[Joe4]

This seems to be a duplicate/continuation of this: Apply Conditional Format to a Named Range

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.