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.

Right-click the shape and go into Format Autoshape.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Alex" <alex-(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>

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 wrote:
> Right-click the shape and go into Format Autoshape.
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "Alex" <alex-(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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.
> >

Not without VBA.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Alex" <alex-(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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 wrote:
> > Right-click the shape and go into Format Autoshape.
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (remove nothere from email address if mailing direct)
> >
> > "Alex" <alex-(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > 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.
> > >
>