When box is checked Yes, how to make the entire column turn grey??

  • Thread starter Thread starter d
  • Start date Start date
Use a linked cell (in an out of the way location) and then use that value as the
rule for conditional formatting.

The details would depend on how you made the checkbox and what version of excel
you're using.
 
Bob I said:
What box?


Im trying to make a entire row shade to gray when it is completed. So when the particular job is completed i put yes in a cell within that row. Is there a formula that would shade the row when I enter the Yes? Hope that helps
Click to expand...
 
use Conditional formatting, formula is, and the cell in question ="yes"
 
You must log in or register to reply here.

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

Find/Replace - from old to new 1
conditional formatting 1
Macro for Varying Number of Rows 0
How do I move entire row from one excel sheet to another 3
How to UN-check greyed-out "First Row Contains Column Headings" bo 0
Excel columns greyed out 8
Check boxes on my custom form 3
Popup Insert greyed out 6

Back
Top