Shading entire rows based on a condition

jason11972

New Member
Joined
Sep 21, 2006
Messages
11
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)
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

texasalynn

Well-known Member
Joined
May 19, 2002
Messages
8,458
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

Legend
Joined
May 15, 2003
Messages
29,536
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

New Member
Joined
Sep 21, 2006
Messages
11
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

Legend
Joined
May 15, 2003
Messages
29,536

ADVERTISEMENT

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

Yup.

Smitty
 

jason11972

New Member
Joined
Sep 21, 2006
Messages
11
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

Legend
Joined
May 15, 2003
Messages
29,536

ADVERTISEMENT

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

New Member
Joined
Sep 19, 2006
Messages
5
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.
 

Forum statistics

Threads
1,137,341
Messages
5,680,922
Members
419,945
Latest member
Carrie Sellers

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top