Try this...

Assume you want to highlight rows where any cell in the range A1:I10
contains the word "listen"...

Select the range A1:I10
Goto the menu FormatConditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:

=COUNTIF($A1:$I1,"*listen*")

Click the Format button
Select the desired style(s)
OK out

--
Biff
Microsoft Excel MVP


"Maureen" wrote in message
...
Thanks, that gives same effect as find/replace with format - highlights
matching cell as expected.
I would guess there isn't a way to highlight a whole row based on a match
in
1 column.

"TomPl" wrote:

Try this:

Select cell A1.
From the menu select <Format<Conditional Formatting
Change drop down to "Formula Is"
Enter this formula =SEARCH("listen",$A$1)0
Select the format you want
Select OK

Test this by typeing "listen" in cell A1 to make sure you get your
desired
format.

Next:
Select cell A1.
Copy
Select all the cells you want to change format when A1 contains "listen"
Paste Speccial, Formats

All of the cells you pasted that format to should now change format based
on
the content of cell A1.

I hope that is clear. Communication can be challenging.

Tom