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


"capital letter" wrote in message
...
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.