Indirect excel functions to use Tables for validation or lookup or functions
To count if a table has more than one of an entry in a column - as a CONDIITONAL FORMATTING: =COUNTIF(INDIRECT("Table[ColID]"),INDIRECT("Table[@ColID]"))>1 Where INDIRECT is the function to return the range "Table" is the named table reference [ColID] is the reference column from the table [@ColID] is the relative 0,0 CELL per iteration of the conditional formatting execution. For DATA VALIDATION (Lists) that grow with tables: =INDIRECT("Table[TableColID]") Where: Table is the name of the data table TableColID is a valid column form the table