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
 
Back
Top