D Dave Peterson Apr 9, 2009 #3 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.
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.
D d Apr 9, 2009 #4 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...
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...