color entire row by using conditional format

C

capital letter

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 ?
 
J

JPA

You may use the "format painter" to replicate the format condition to the
other cells.



"capital letter" escreveu:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

color entire row by using conditional format 1
Highlight Rows 8
Highlight rows if column A matches but B is different 0
Find number within two data base 2
Excel 2010 Conditional Formatting 2
Conditional formating a cell containing a date 1
Conditional format stoplight based on worst color 3
conditional format of entire row based on a single cell in row 7

Top