Drop down box

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
 
B

Bob Phillips

Why not just set the cell colour?

--

HTH

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

mark

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
 
B

Bob Phillips

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)
 
G

Guest

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...
 
Top