Salutations and G'd day,
I have an array, $C$3:$C$102 that is named Summary_Expense_Center. I am trying to use this name in a formula to conditionally format $D$n:$F$n where n is the current row (@) in those columns.
The formula I'm using in the conditional format is:
(Summary_Expense_Center is the spill of an array formula.)
If true I change the background color, if false... no change.
I've typed myself bloody trying to find a go or no-go on the use of named arrays used this way. No mention either way.
Thanks all for a hint, pointer, affirmation or denial
Same as with tables, INDIRECT. On this sample
Thank you! A very simple yet elegant solution to a rather vexing problem. A slight adaptation and I was able to accomplish my goals!
John, glad to help. Good luck with dynamic arrays, there's a lot of news here for each of us.