Change control color

[Alex]

Many thanks to everyone on this newsgroup. Even if I havn't posted
much, I still learn a lot from reading other people's discussion
threads!

Anywho, my question: Is there a way to change a control's color based
on a cell's value without using VB?

Specifically, I want to change the fill color for a Oval drawing
control from green to red and back again.

If I can't do this outright, then I will probably rig something using
Conditional Formatting and background colors.

Thanks in advance!

Alex Brewer.

 

[Bob Phillips]

Right-click the shape and go into Format Autoshape.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Alex]

Thanks for the suggestion, but that will only work manually. I am
looking for something like Autoformat that will do it based on the
value in a specific cell.

I can probably write some VB to do it, but I want to avoid that if
possible.

Thanks!

Alex.

 

[Bob Phillips]

Not without VBA.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)