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?