You can made an entire row respond to a single cell entry with conditional
formatting quite easily.

Say you want a format change to all of row 1 when cell A1 has the value 100:

-Select the entire row.
-In the Conditional Formatting dialog select "Formula is" from the Condition
1 drop down.
-Use =$A$1=100 as the formula (the "$" are important)
-Enter the desired format.

--
Jim
"CBD" wrote in message
...
| Not sure if this is possible... I have applied conditional formatting to a
| cell in a row of information, to fill with colour on input of a specific
| answer from a drop down.
|
| Can I make the whole row change to the same colour along with the cell on
| input of the answer.... can't find out how.
|
| Any help much appreciated.
| thanks