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

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
you want to make a conditional format
Select the row then select Format - Conditional Format - Formula
=c2="YES"
then select the format pattern green.
 
Upvote 0
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
 
Upvote 0
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....
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,218,899
Messages
6,145,099
Members
450,590
Latest member
Naneng

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
Back
Top