"For Each" statements
Thank you SO much Paul. It worked like a charm.
Best Regards,
Michael
"PCLIVE" wrote:
This should get you started.
For Each cell In Range("F1:F65536")
If cell.Value = "X" _
Then
cell.EntireRow.Select
With Selection.Interior
.ColorIndex = 6
.Pattern = xlSolid
End With
Else:
End If
Next cell
This changes the background color of the entire row to yellow if the value
of the cell in column F is "X". Modify as necessary.
HTH,
Paul
"MGSurberDallas" wrote in message
...
I am relatively new to programming. Can anyone suggest the code for the
following:
I want to highlight each row that contains a certain value in a particular
column.
For Each Row that contains X in Cell F
then highlight row.
Can anyone get me started? Thanks Michael
|