Hi,
I need to highlight the range from A to K where the Column G contains FB01. It will be great if somebody can help me with a VBA code. As I will append it after some existing code.
At present I am using this code but it's highlighting the entire row. Also it's taking a lot of time as I believe i am making some mistake.
Sub highlight()
   Dim cell As Range
    Range(Range("G1"), Range("H1").End(xlDown)).Select
   For Each cell In Selection
      If cell = "FB01" Then cell.EntireRow.Interior.ColorIndex = 4
   Next cell
End Sub
Thanks for all your help.
Regards,me