How can I use conditional formatting in an Excel table using structured referenc...

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?

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

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

    _{click for larger image}