color entire row by using conditional format

C

capital letter

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.
 
M

MartinW

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

Top