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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional format an entire row 1
Conditional formating an entire row vs. only one cell 1
Conditional Formating 2
Inserting a Copied Row inside a table 6
Conditional Formatting, Icons 1
Conditional Formatting based on dynamic Date 1
Copying Row Code Doesn't Copy Conditional Formating 10
Another Conditional Formatting Question 2

Back
Top