conditional formatting of row based on cell

  • Thread starter Thread starter Katherine
  • Start date Start date
K

Katherine

I want to apply conditional formatting to a whole row
based on the contents of one cell in that row.

For example, if cell L2 contains the word 'sport', i want
the whole of row 2 to be shaded.

I'm guessing this is pretty simple, but seem to be having
a bit of a mental blockage.

Any suggestions would be appreciated. Thanks :)
 
One way is to select your rows to have this first. Then write your formula
using the active cell's row--in my example the active cell was in Row 2.

Format|conditional formatting|formula is:

=COUNTIF($L2,"*sport*")>0
 
Back
Top