On Tue, 14 Jun 2005 02:24:03 -0700, "olympiad"
wrote:

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

Select C1:J1

Format/Conditional Formatting/Formula Is:

=AND($C$1:$J$1<"")
(do not set a format for this condition)
<Add

Formula Is:
=$C$1<""

Format this condition to taste.

The above will turn C1:J1 to your format for condition 2 when you enter
something into C1. When all cells have an entry, the format will return to
your default.

If you wish to be able to apply this to other rows, change the cell references
by removing the "$" in front of the row number: $C1:$J1


--ron