• 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

    Hui...

  • 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

sampal

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?
 
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.
 
Back
Top