Conditional formatting - highlight an entire row

  • Thread starter Thread starter Dave K
  • Start date Start date
D

Dave K

Is there a way to use conditional formatting so that if the contents
of a single cell changes, then the entire row in that table will
change a color.

I know it can be applied to the cell, but can it be applied to the
entire row?

Thanks.
 
Select row 1 as an example.

Format>CF>Formula is: =$A$1="OK"

Note the $ signs.

If you want to copy this to other rows, make it $A1


Gord Dibben MS Excel MVP
 
Back
Top