Select all the cells (click above and to the left of cell A1), and then
choose Format / CF...  use "Formula is" and the formula

=COUNTIF(1:1,"*auto-renew*")>0

and set your formatting as desired.

HTH,
Bernie
MS Excel MVP

Hi,

The Conditional-Formatting formula you have to use depends on where the word
"auto-renew" can occur in the spreadsheet.  

Let us imagine that the data are in columns A:E and rows 2:101 (i.e., the
data range is A2:E101).  Select the entire data-range (STARTING with A2), and
use one of the following CF formulas depending on the scenario.

If the word "auto-renew" can occur in one or more cells in ONLY ONE column
(say Column A) and you want to highlight the corresponding rows, the formula
is,

=$A2="auto-renew"

If, on the other hand, the word can occur in one or more cells ANYWHERE in
the spread-sheet and you want to highlight the corresponding rows, the
formula is,

=ISNUMBER(MATCH("auto-renew",$A2:$E2,0))

Regards,
B. R. Ramachandran