conditional formatting using contains

N

nic4asu

Can I specify a formula where I highlight the entire row if one cell contains
the word "auto-renew"?
 
B

Bernie Deitrick

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
 
B

B. R.Ramachandran

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
 
Top