Using named array in a conditional format formula

[TheOldPuterMan]

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<>"",1)

(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

TheOldPuterMan

(John)

[#2]

Hi John,

Same as with tables, INDIRECT. On this sample

=@INDIRECT("Summary_Expense_Center")=5

@TheOldPuterMan 

[#3 · Accepted solution]

@Sergei Baklan 

Sergei,

Thank you! A very simple yet elegant solution to a rather vexing problem. A slight adaptation and I was able to accomplish my goals!

Much appreciated,

TheOldPuterMan

John

[#4]

@TheOldPuterMan ,

John, glad to help. Good luck with dynamic arrays, there's a lot of news here for each of us.