formatting excell

V

Vstar1969

How do I make an entire row change to a new color if one cell in that row
gets any data entered into it?
 
D

Dave Peterson

Select your range.

I selected A1, then selected the whole worksheet (ctrl-a (twice in xl2003))

Then with A1 the activecell.

format|conditional formatting
I used a formula of:
=counta(1:1)>0

and formatted the pattern nicely.
 
Top