formatting excell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I make an entire row change to a new color if one cell in that row
gets any data entered into it?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to filter rows data based on background color of individual cells 1
Conditional formatting in Excel 2010 2
Text Color Changes By Itself 3
Expand Conditional Formatting to all Rows 7
How to set up so that if I enter an "X" in one cell it would color 4
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Copy paste data from a column to a row 0
Conditional Format a range based on 1 cell 1

Back
Top