Hi

With C1:J1 selected, select from Format menu 'Conditional formatting'.

Select 'Formula Is' and enter the formula
=AND($C$1<"",$F$1="")
Click on Format button, set pattern color for case the condition is true.
OK.
OK.
It's done!

--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )



"olympiad" wrote in message
...
Would it be possible to use conditional formatting for my problem below,
if
so could I please get some assistance how to construct the formula.

For example, what I would like to achieve is that if data is entered in to
cell C1, I would like all cells from C1 to J1 change to a different
color,(all at once) and that color would remain in all those cells even
when
data is entered in to some of the other cells. In addition, if possible I
woul like all cells to go back to normal when data is entered in the the
final cell J1.

It would be great if someone could find the solution to this.

Many thanks

Olympiad