color entire row by using conditional format

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

Guest

I have some data in a1:f110, & in f1:f110 is data validation (list) i.e.
"Reject", "Accepte", "Pending". Now I want that if I select "Reject" or
"Accept" or "Pending" in data validation list cell then it will be color
entire row as per my color. So I have made a conditional formating like
formula is =$f$1="Reject", format patern is red color
formula is =$f$1="Accept", format patern is green color
formula is =$f$1="Pending", format patern is yellow color.
but the problem is that if I select any list of data in validation column
then it just color only active cell but not whole row, what's the wrong with
me.
 
Hi,

As already suggested you can use the Format Painter to drag it across
as far as you need, or you can simply select the entire row *before*
you apply your Conditional Formatting.

HTH
Martin
 

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

color entire row by using conditional format 1
Highlight Rows 8
Excel VBA 1
Conditional formatting dates 3
change color of entire row by use conditional format 2
Conditional format stoplight based on worst color 3
Conditional Formatting Formula? 5
Conditional formatting excel 2003 2

Back
Top