Conditional Formating Based on Selection in a Combo Box
 

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?

Conditional Formating Based on Selection in a Combo Box
 

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 FormatConditional Formatting
3. For Condition1Select 'Formula Is' and enter the below formula
=$J1<""
4. Click Format ButtonPattern and select your color (say Red)
5. Hit OK

--
Jacob


"adrian007uk" wrote:

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?

Conditional Formating Based on Selection in a Combo Box
 

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

"Jacob Skaria" wrote:

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 FormatConditional Formatting
3. For Condition1Select 'Formula Is' and enter the below formula
=$J1<""
4. Click Format ButtonPattern and select your color (say Red)
5. Hit OK

--
Jacob


"adrian007uk" wrote:

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?

Conditional Formating Based on Selection in a Combo Box
 

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"




--
Jacob


"adrian007uk" wrote:

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

"Jacob Skaria" wrote:

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 FormatConditional Formatting
3. For Condition1Select 'Formula Is' and enter the below formula
=$J1<""
4. Click Format ButtonPattern and select your color (say Red)
5. Hit OK

--
Jacob


"adrian007uk" wrote:

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?

Conditional Formating Based on Selection in a Combo Box
 

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

"Jacob Skaria" wrote:

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"




--
Jacob


"adrian007uk" wrote:

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

"Jacob Skaria" wrote:

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 FormatConditional Formatting
3. For Condition1Select 'Formula Is' and enter the below formula
=$J1<""
4. Click Format ButtonPattern and select your color (say Red)
5. Hit OK

--
Jacob


"adrian007uk" wrote:

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?