Shading row based on value in one of its columns

  • Thread starter Thread starter EAPS
  • Start date Start date
E

EAPS

I have a spreadsheet and want to make it automatically shade any rows that
have the words “NO BID†in column D. I’ve been trying to figure this out
using conditional formatting, but have had no luck with higlighting ENTIRE
ROWS. Please help. Thanks!
 
Highlight the rows desired at the row NUMBER on the left.At the first row in
selection if row 21

formula=$d21="NO BID">format as desired
 

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

alternate row shading on filtered data 2
Formatting rows 10
Partial Shading in Excel 2003 4
Row shading based on criteria 6
Excel 2007 Autofit 4
Conditional Formatting of Entire Row when the Active Cell is in ro 11
Changing Row Color 13
Conditional formatting with time 4

Back
Top