Formatting a row based on cell content

[John Corbin]

If a cell in column G contains a certain word,. I would like to:

Highlight the row in Yellow
Bold the text.

Columns go form A to AH and nothing should be formatted for any non
used cell


can any one point the way ?

 

[Bob Phillips]

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

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[John Corbin]

Seehttp://www.contextures.com/xlCondFormat01.html

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)









- Show quoted text -

I saw that earlier... Is there a way to do it via VBA ?

 

[Bob Phillips]

If Range("G2").Value = "certain word" Then

Range("A2:AH2").Interior.Colorindex = 6
End If

--
__________________________________
HTH

Bob

Seehttp://www.contextures.com/xlCondFormat01.html

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)









- Show quoted text -

I saw that earlier... Is there a way to do it via VBA ?