• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Structured References in Conditional formatting


New Member
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?

Luke M

Excel Ninja
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.