Another 'IF cell contains THEN color row' Question
 

I have been researching this for hours. I have a large spreadsheet
that I want to apply a conditional formatting scheme where if any cell
in column AC contains 'FMRR' then color that row green. If the cell in
AC does not contain FMRR then do nothing.

The operator 'CONTAINS' does not exist in conditional formatting,
therefore I cannot see how I can use it. The FMRR numbers contain
numbers aswell. For example 'FMRR-01234' therefore I need to query on
contains 'FMRR'.

Any advise?

Another 'IF cell contains THEN color row' Question
 

In Conditional Formatting, use Formula Is =FIND("FMRR",$AC1)
--
David Biddulph

"BeatonD" wrote in message
ps.com...
I have been researching this for hours. I have a large spreadsheet
that I want to apply a conditional formatting scheme where if any cell
in column AC contains 'FMRR' then color that row green. If the cell in
AC does not contain FMRR then do nothing.

The operator 'CONTAINS' does not exist in conditional formatting,
therefore I cannot see how I can use it. The FMRR numbers contain
numbers aswell. For example 'FMRR-01234' therefore I need to query on
contains 'FMRR'.

Any advise?