color entire row by using conditional format
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. |
color entire row by using conditional format
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. |
All times are GMT +1. The time now is 07:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com