Conditional formatting - highlight an entire row

[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.

 

[Gord Dibben]

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