automated cell coloring

J

JT

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
 
F

Frank Kabel

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
 
B

Bob Phillips

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)
 
Top