Hey Chandoo, the structured references are not working when i am putting formula in conditional formatting. It says my formula has error, why is that. Named ranges are fine but table references are not working? any ideas?
I'm not sure "why" it does that, but a work-around is to create a Named Range that equals the structured reference, and then use the Named Range in the conditional formatting.