I'm getting my head around the use of formulas (particularly in the service of conditional formatting) but can't find the answer to a basic question: How do I reference another specific shape?
Here's the scenario: I have a group composed of one circle and one text box. I want the circle to take on a color based on the value contained within the text box. I understand I need a formula for the conditional formatting of the circle and I know the value I'm going to test is the text of the text box but I'm not sure how to reference that text box within the same group.
Can you provide an example?
