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.