conditional formatting referring to table data

[zico8]

I have sheet with conditional formatting in cell J2.
This cell should be filled yellow if number of cells in my table that contain value = 2 is greater than 2.

I reffer to my table by =COUNTIF($A$2:$C$4;2)>2

I would like to do the same in cell J1 and use the data table reference =COUNTIF(Table1;2)>2 but it does not work.

Is it possible to address like this? Why I get error when trying to this?

[TMS]

You need to "cheat" a little with Structured Table references in Conditional Formatting

Use:

Please Login or Register  to view this content.

Regards, TMS