VBA: Code needed for highlighting row if it contains certain info

[bamaisgreat]

Thanks for looking.Im looking for some code where if the cell contains the value G4474 it will highlight the row. The value could be different variables such as G4474-456-5 or G4474-200 or just G4474 and so on.....

 

[Joe4]

VBA may not be necessary. It can be done with Conditional Formatting.

Assuming you have Excel 2007 or higher, and let's assume you are checking the entries in column A starting in row 1. Highlight all your rows, and enter this Conditional Formatting formula:

=IFERROR(FIND("G4474",$A1),0)>0

and select your highlighting option.

 

[bamaisgreat]

thanks worked great