Highlighting a whole row?

[hsarrategui]

I have created a spread sheet for leads. One of the boxes requires a yes or no entry. Is there a formula I can use or formatting that will highlight the enter line if "yes" is but in that box?

 

[MARK858]

One of the boxes requires a yes or no entry

Do you mean a cell? if yes which one?

 

[hsarrategui]

Do you mean a cell? if yes which one?

Column "J" would be the one with yes or no in the box. And then each row of the list I'm making with the yes in that column I would want highlighted. The ones that would have YES as the answer I want highlighted so I can monitor the outcome of the application

 

[LegendaryAxe]

Does this work?

Book2
	A	B	C	D	E	F	G	H	I	J
1	Column1	Column2	Column3	Column4	Column5	Column6	Column7	Column8	Column9	Column10
2										YES
3
4
5
6
7
8										YES
9
10
11
12
13										YES
Sheet7

Cell Formulas
Range	Formula
A1:J1	A1	="Column" &COLUMN()

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:J13	Expression	=$J2="YES"	text	NO

 

[hsarrategui]

Does this work?

Book2
	A	B	C	D	E	F	G	H	I	J
1	Column1	Column2	Column3	Column4	Column5	Column6	Column7	Column8	Column9	Column10
2										YES
3
4
5
6
7
8										YES
9
10
11
12
13										YES
Sheet7

Cell Formulas
Range	Formula
A1:J1	A1	="Column" &COLUMN()

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:J13	Expression	=$J2="YES"	text	NO

yes! this is exactly what I am looking for! How do I set it up? You're amazing! Thank you!

 

[LegendaryAxe]

Highlight the range you want the conditional formatting applied to, hit alt O D, click "New Rule" then click the bottom option ("Use a formula..."). Put the formula I provided below "Format values where this formula is true" and then click the "Format," choosing the formatting and then click "OK."

 

[hsarrategui]

Highlight the range you want the conditional formatting applied to, hit alt O D, click "New Rule" then click the bottom option ("Use a formula..."). Put the formula I provided below "Format values where this formula is true" and then click the "Format," choosing the formatting and then click "OK."

Its not working? I don't think I am doing this right

 

[MARK858]

Delete both those rules and see if you can follow the instructions below

• Select row 2 down to the last row you want
• Click Home Tab if not already selected
• Click Conditional Formatting icon in the Styles area
• Click New Rule button
• Click Use a formula to determine which cells to format
• In the box that says Format values where this condition is true type the formula

  =$J2="YES"

• Click Format button
• Click the Fill tab
• Choose your formatting
• Click OK
• Click Ok

or

• Select row 2 down to the last row you want
• Hold Alt press O press D
• Click New Rule button
• Click Use a formula to determine which cells to format
• In the box that says Format values where this condition is true type the formula

  =$J2="YES"

• Click Format button
• Click the Fill tab
• Choose your formatting
• Click OK
• Click Ok

 

[hsarrategui]

Delete both those rules and see if you can follow the instructions below

• Select row 2 down to the last row you want
• Click Home Tab if not already selected
• Click Conditional Formatting icon in the Styles area
• Click New Rule button
• Click Use a formula to determine which cells to format
• In the box that says Format values where this condition is true type the formula

  =$J2="YES"

• Click Format button
• Click the Fill tab
• Choose your formatting
• Click OK
• Click Ok

or

• Select row 2 down to the last row you want
• Hold Alt press O press D
• Click New Rule button
• Click Use a formula to determine which cells to format
• In the box that says Format values where this condition is true type the formula

  =$J2="YES"

• Click Format button
• Click the Fill tab
• Choose your formatting
• Click OK
• Click Ok

THAT WORKED!!!! THANK YOU SO MUCH!!!

 

[MARK858]

You're welcome, happy we could help