If the word is the only thing in the cell, you can just use simple
conditional formatting with a conditional test of equal to the word.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"JT" wrote in message
...
i have an excel document made of up 5 columns and a lot of rows.

how can i check to see if a specific word exists in a row, and if the word
is found, then shade the 5 columns that make up the row a color of my
choice??

thansk for the help