automated cell coloring
 

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

automated cell coloring
 

Hi
try the following:
- select cells A1:F40
- goto 'Format - Conditional Format'
- enter the following formula:
=ISNUMBER(MATCH("your_word",$A1:$F1,0))
- choose your format

--
Regards
Frank Kabel
Frankfurt, Germany


JT wrote:
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

automated cell coloring
 

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