Shading entire rows based on a condition

[jason11972]

I know how to make a cell change color based on the choice you make in the drop down box...but how do I get the entire row that cell is on to switch to that color when the choice is made?

(ex. When you choose "Yes" the box turns green. I want the entire row to turn the same color simultaneously)

 

[texasalynn]

you want to make a conditional format
Select the row then select Format - Conditional Format - Formula
=c2="YES"
then select the format pattern green.

 

[Smitty]

Welcome to the Board!

You can select the entire row and goto Format-->Conditional Formatting-->Formula Is-->=$A1="YES"-->Format-->Pattern-->Green.

Adjust the cell reference as necessary.

Hope that helps,

Smitty

 

[jason11972]

I cant get it to work. It's not changing the color of the row when I choose the yes/no option. I'm assuming that since it's in row A3...that I use that instead of A1 you posted....

 

[Smitty]

I'm assuming that since it's in row A3...that I use that instead of A1 you posted....

Yup.

Smitty

 

[jason11972]

Frustrating. Still not working. I'm just trying to get A3 thru H3 to turn green when I choose the yes option in G3...and still no luck. I'll keep playing with it I guess.

 

[Smitty]

I'm just trying to get A3 thru H3 to turn green when I choose the yes option in G3...

Select A3:H3-->Format-->Conditional Formatting-->Formula Is-->=$G3="YES"-->Format.

Smitty

 

[Tyler]

All though most may see this as very basic and obvious make sure that you have the quotations around the "yes" in your conditional formating or nothing will happen. I was trying to do the same thing but without the quotaitions it wont recognize the yes or no.

 

[jason11972]

Yes...I knew that. Thanks for the help btw...I did get this to work for me.

 

[texasalynn]

so care to share what the issue was? in solving