Conditional formatting

O

olympiad

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
 
R

Ron Rosenfeld

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
Click to expand...

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
 
A

Arvi Laanemets

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!
 
Top