Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formating - dragging a cond. format over an entire col | Excel Worksheet Functions | |||
color entire row by using conditional format | Excel Worksheet Functions | |||
Conditional format based on entire row | Excel Worksheet Functions | |||
HOW CAN I APPLY A COLOR TO ENTIRE ROW USING CONDITIONAL FORMATT | Excel Worksheet Functions | |||
Conditional Format to Highlight entire Row? | Excel Worksheet Functions |