Highlighrt a Row

  • Thread starter Thread starter Dave
  • Start date Start date
In Conditional Formatting, use "Formula Is" rather than "Cell Value Is", and
use an absolute reference for the column and relative reference for the row,
e.g. Formula Is =$L1=42
 

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

I can only delete an entire row not a cell in excel 2013? 1
Highlight more than one entire row when cells = TRUE 5
Highlighting Entire Row without the Mouse 11
Conditional Formating - by row, not by column (Office 2007) 1
Need to highlight cells in special order 0
Having an entire row highlighted as I move from cell to cell 8
Conditional Formatting 2 rows only 2
Conditional formatting Entire Row Based on single Cell Value 5

Back
Top