i’d like to reference an object (autoshape) in a simple excel formula. specifically, i want to use an if-then statement to display a green up-arrow (created using autoshapes) when a condition is true and a red down-arrow (also created using autoshapes) when the condition is false. i can only get the formula to reference a specific cell and not an object.
thanks…
lee