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("col1")=INDIRECT("col2"):
But all that did was colour the entire column col2 green.
Anyone know how to do this?
