So, I'm not quite sure how to make that work on the whole worksheet or format
the whole row.
I can add another column that uses =SEARCH("listen",A1)0, copy the formula
all the way down the worksheet, then do a conditional format for the value
"TRUE" but it only applies the conditional format color on the cell
containing the word 'TRUE' not the whole row.
If it try to do conditional format on a range ie.
=SEARCH("listen",A1:I5000)0, I get odd results.
Column I is the column that may contain the word 'listen'. If it finds
'listen', I want the row A15:I15 to be highlighted.


"TomPl" wrote:

When setting up conditional formatting select "Formula Is" then enter this
formula:

=SEARCH("listen",A1)0

The cell I referenced (A1) is the same cell that is being formatted.

You could affect the whole row by putting this conditional formating in the
whole row but always reference cell (A1) or whatever cell you decide is the
key.

Hope this works for you.

Tom