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


"nic4asu" wrote in message
...
Can I specify a formula where I highlight the entire row if one cell
contains
the word "auto-renew"?