Forum Discussion
Index Match Conditional formatting
I have two tables There are for instances unique employee ID in look up column and then dates like on column DB8. Table 1 - Table 2 - is the holiday table it matches the employee ...
You need to use the INDIRECT function for the table call outs. The conditional formatting formula block won't recognize your table name as a table so you need to input it as INDIRECT("Table1[Column]"), where Table 1 is the table name, and Column is the table column you're referencing. The table and column need to be in quotations.