How can I use conditional formatting in an Excel table using structured references?

Question

I believe I am correct in saying that a reference to a column in a table (e.g. table1["col1"]) is known as a structured reference as opposed to an absolute reference (e.g. A1:A5).

I would like to know if it is possible to use structured references in a table. This post: Structured table references in conditional formatting formulas suggests that it is possible using INDIRECT()however I cannot figure out how to achieve what I need. I'll explain.

Take this contrived example:

This is a table. I would like the value in col2 to be coloured green if it is equal to the value in col1, and I'd like to use conditional formatting to do it. Essentially I want it to look like this:

I attempted to "Use a formula to determine which cells to format", the formula is =INDIRECT("Table1[col1]")=INDIRECT("Table1[col2]"):

But none of the cells changed their formatting.

Anyone know how to do this?

Answer 1

Include the table name and add the @ symbol to reference row for row.

=INDIRECT("Table1[@col1]")=INDIRECT("Table1[@col2]")

    _{click for larger image}

Answer 2

For me the following works: first cell of the column to be formatted is selected, then conditional formatting --> use a formula --> edit rule: put in table column to be formatted = column to compare to the first cell should be formatted now. Then I used format painter for the rest of the column, in your case Col2. it worked for me, hope it works for you as well. - Martijn

Disregard: After rechecking the effects, I noted the conditioning does not work.