Conditional formatting on a spilled range

Question

(* This might be a duplicated question, but it would be surprising if we don't have this feature yet. *)

I have a table Table5 in Column C, whose height may change. in Column E, I have a formula to e.g., extract unique values, thus the resulting spilled range has a dynamic height.

I would like to make a conditional formatting over the resulting spilled range, for instance, highlight the value which is greater than 5.

But I didn't find how to define a conditional formatting rule over a spilled range (e.g., by using #). I don't want to apply the conditional formatting rule over the whole column.

Does anyone know how to achieve this?

Answer 1

The only way I could think of was:

=AND(ROW($E1)>=4,ROW($E1)<=COUNTA(UNIQUE(INDIRECT("Table5[Coefficient]")))+4,$E1>5)

Use the above formula as a conditional formatting rule on the whole of column E:E.