Select A14:J77 (with A14 active) and then:

Format | Conditional Formatting | Formula Is | =$E14=1 | Format | Patterns |
Yellow | OK | OK

--

Vasant




"Tim" wrote in message
...
Dear all !

I have in one spreadsheet, ten columns (from A14 to J77) which are doing
different calculations.
Because of the nature of calculations one of cells in column E has to be
equal to 1.

My question is:
If lets say cell e60 turns to be 1. Is there any way to color
automatically
this cell and all the other cells in row from A60 to J60 (lets say in
Yellow)

Thank you in advance