Say I have a conditional format rule in cell C1 that says =VLOOKUP(B1,INDIRECT(A1),2,FALSE)=C1
In cell A1, I have a named range, which changes going down the column... A1 = Atablearray, A2 = Btablearray, so forth
I want to be able to copy the conditional format rule down the column and have the vlookup conditional format formula update with the correct table array for that row.
I can get this to work if my table arrays are fixed, but when I put in a variable defined table array using OFFSET, it doesn't work anymore. (See my example for conditional format rule in cell D1).