Conditionnal formatting with reference to an array

Hi there,

First post for me in this forum!

I have a problem trying to apply a conditionnal formatting that contains a reference to a named array.
See the attached MWE: the conditionnal formatting formula (applied to cells C1:C20) refers to the range named "Range1" (A1:A6) and everything works fine. But if, in the formatting formula, the "Range1" is changed to the array "Array1" (that corresponds to the exact same range of cells as "Range1" in the worksheet), an error message pops up.
Can anyone help? Or is this simply the normal behaviour?

Matt

CondtionnalFormattingArrayMWE.xlsx

Hi simarui and MarvinP,

Thank you very much for your help, it indeed works very well now, both in the MWE and in my actual worksheet.

Now, this triggers another question: suppose for some reason, the table name is modified by some unaware user. Is it possible to dynamically change the name in the string? I.e. is it possible to convert a table name to a string? Or I am nitpicking?

Matt

@MarvinP: Yes, and what I called "array" is actually a table in the English version (my Excel is in French). If I had known that earlier, maybe I could have find the solution myself :-)

Hi MarvinP and simarui,

Yes, changing the name in the Name Manager has an effect "only" on the formulas (which is great) but unfortunately it does not affect the string corresponding to that name.

@simarui: this is very neat! I'll do that on Monday morning.

Anyway, the main problem has been very efficiently solved.
Ladies/gentlemen, once again thanks for your help.

Matt