plz see the attached file.
i have two sheets that i have highlighted ListB with Conditional Formatting COUNTIFS formula and i used named range.
=COUNTIFS(Product,$A2) Product is the named range. it perfectly works.
Now, i tried this with another senario, i have two sheets and in the " ListB HighlightNEED" i want to highlighted similar to the previous senario but this time using the table column name =COUNTIFS(Table[Product],$
A2) but excel does not allow me to use this. i was wondering how to refer the table column in the abovementioned formula inside condtional formatting.