Conditional Formating Based on Selection in a Combo Box

  • Thread starter Thread starter adrian007uk
  • Start date Start date
A

adrian007uk

Hello,

I am using Excel 2003. I have a combo box at the end of each row where you
can select one of eight options. What i would like to do is when an option
is selected the row changes to a particular colour. Is there any way to do
this?
 
Hi Adrian

Do you mean a combo box from Control toolbox or a drop down..If that is a
combo
box then link each combobox to the cell behind say in Column J..and follow
the below instructions to conditional format the cells

1. Select the cell/Range (say A1:J10). Please note that the row number
referenced in the formula is the row with the active cell in the selection.
Active cell will have a white background even after selection
2. From menu Format>Conditional Formatting>
3. For Condition1>Select 'Formula Is' and enter the below formula
=$J1<>""
4. Click Format Button>Pattern and select your color (say Red)
5. Hit OK
 
Hi Jacob

Thanks for the reply. I have tried your suggestion and got a row to change
colour. However, i don't think i made myself very clear in my previous post
(sorry about this).

I made a combo box from the "forms" toolbar. I have populated the combo box
with options such as "On Order", "In Stock", "Missing" etc. What i am
wanting to do is when an item is "On Order" the option is slected in the
combo box for the row to go green for example. When the item comes "In
Stock" the combo box is changed to reflect the "In Stock" option and as a
result the row changes to say the colour pink.

Adrian
 
Same as previous except change in Conditional formatting formulas

Conditional formatting condition 1 formula ...and select your color
=$J1="On Order"

Conditional formatting condition 2 formula ..and select your color
=$J1="In Stock"

Conditional formatting condition 3 formula ..and select your color
=$J1="Missing"
 
Hi Jacob

That made more sense to me however, i still cannot get it to work. I have
follwed your instructions. I have populated the combo box from a range.
Should i manually populate the combo box myself and if so how do i do that
(Does that make a difference)?

Thanks

Adrian
 
Back
Top