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