Drop down box

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

I have a combo box with a list of five items hidden on
the spreadsheet.
How can I either change the combo box color or the color
of the cell next to it.
I have tried conditional formatting but this does not
work within the combo box.

Thanks

Mark
 
Why not just set the cell colour?

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
AS in the combo box i have the following colors Red,
Amber, and Green. when you select this color i would like
the cell or combo box to change to this if possible.

thanks
 
Got you.

Link a cell to the combox and test that in CF.

Remember, the forms combo returns the index, the control toolbox combo
returns the value.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
cheers worked a dream
-----Original Message-----
Got you.

Link a cell to the combox and test that in CF.

Remember, the forms combo returns the index, the control toolbox combo
returns the value.

--

HTH

RP
(remove nothere from the email address if mailing direct)





.
Click to expand...
 
Back
Top