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?