Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hello!
I am attempting to make a macro that will select a range and look in column B for an "X" If that condition is met, I would like it to highlight the entire row, or if it would be easier, to highlight the row in columns A - M. I have worked on the macro below and I can get the cells with "X" in the column to hightlight, but I cannot get it to select the entire row. If there is an easier way to accomplish this I would welcome the suggestion...this is what I'm currently using. Rows("4:4").Select Range(Selection, Selection.End(xlDown)).Select Dim Cell As Range For Each Cell In Selection If Cell.Value = "x" Then Cell.Interior.Color = vbGreen Else End If Next Cell End Sub Thanks in advance for you help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Want to highlight all but first line | New Users to Excel | |||
Want to highlight all but first line | New Users to Excel | |||
How do I count number of cels the matches 2 conditions ? | Excel Worksheet Functions | |||
How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions | |||
average on 2 conditions | Excel Worksheet Functions |