Use conditional formatting.

See http://www.contextures.com/xlCondFormat01.html

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"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