Auto formatting fill color

b_bears

New Member
Joined
Oct 2, 2006
Messages
2
Have a spreadsheet and when a completion date goes in a cell I want the entire row of cells to change from the white background to a green background. Tried with conditional formatting but was only able to change the single cell not the whole row. Any ideas, thanks in advance.
 

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

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
Welcome to the Board!

If you highlight the entire row, you can use something like this in Conditional Formatting-->Formula Is-->=$A1<>"".

Just adjust the range & criteria to suit.

Hope that helps,

Smitty
 

forethot

New Member
Joined
Oct 2, 2006
Messages
1
Similar Question - Highlighting a Row

I have a similar question. I would like to highlight a whole row based upon the value of a column. For example, if I have a column with 6 values, for example 30, 35, 40, 60, 60, 75, I would like the rows with the value of 60 to be highlighted/formatted grey.

Any help would be appreciated.

Thanks!
 

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
No problem.

Highlight your range of rows and goto Format-->Conditional Formatting-->Formula is-->=$A1=60-->Format as desired. Where $A is the target column.

HTH,

Smitty
 

b_bears

New Member
Joined
Oct 2, 2006
Messages
2
Pennysaver
Thanks for such a quick reply. Your solution works great!!!

Thanks
 

Forum statistics

Threads
1,136,612
Messages
5,676,800
Members
419,651
Latest member
alexanderguhr

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