Conditional formatting based on values in another table

[whitehawk81]

Hi everyone!

I haven't posted any issues for a while, but this one really got me or I'm just getting older
Basically I would like to format the cells based on the result of a lookup value from another table.
I managed to apply the index match formula to return the value, that needs to be evaluated, but when I put it in the conditional formatting, it doesn't find anything.

The formula looks like this: ="INDEX(Table2;MATCH(J4;Table2[Change];0);1)=$X$3"

I also tried it with index/match multiple criteria array formula: ="INDEX(Table[Env];MATCH(1;($I5=Table[Planname])*(K$3=Table[Date]);0))=$X$3"

Could someone help me?

 

[Fluff]

You need to remove the "s from around the formula, I suspect that you may need to change the structured references to cell references as well.

 

[whitehawk81]

Thank you! Both of your comments were right I managed to format the cells with the array formula.

 

[Fluff]

Glad you sorted it & thanks for the feedback