View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MGSurberDallas MGSurberDallas is offline
external usenet poster
 
Posts: 4
Default "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