| 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:G10, & F1:F10 is validate cell (List), i.e.
"Reject","Accepted","Pending", now i want to change the color of whole row if I select "Reject" or "Accepted" or etc. in F column. I have made a C.F. i.e - Formula is =$f$1="Rejected", format patern is red color, Formula is =$f$1="Accepted", format patern is green color, Formula is=$f$1="Pending", format patern is yellow. My problem is that when I select "Reject" or "Accepted" or "Pending" then only the F1 cell is being color not whole row. What should i do ? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
color entire row by using conditional format
You may use the "format painter" to replicate the format condition to the
other cells. "capital letter" escreveu: I have some data in A1:G10, & F1:F10 is validate cell (List), i.e. "Reject","Accepted","Pending", now i want to change the color of whole row if I select "Reject" or "Accepted" or etc. in F column. I have made a C.F. i.e - Formula is =$f$1="Rejected", format patern is red color, Formula is =$f$1="Accepted", format patern is green color, Formula is=$f$1="Pending", format patern is yellow. My problem is that when I select "Reject" or "Accepted" or "Pending" then only the F1 cell is being color not whole row. What should i do ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formating - dragging a cond. format over an entire col | 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 change entire row based on one cells data | Excel Discussion (Misc queries) | |||
| Conditional Format to Highlight entire Row? | Excel Worksheet Functions | |||
Linear Mode
