Color checkbox cell based off checked/unchecked box and date due in Excel

mtarler So I will not do all the work 🙂 but will try to give you enough to see what to do.

As i noted above first assign a cell for each checkbox (this will be annoying and I think if you did it first and then copied the checkbox it may have auto incremented and made it easier).  So right click and choose Format Control... then under Cell Link select the cell under the box.

   > > > >    

now when you click the box the cell will reflect the value of the box:

As I mentioned you can easily change the text color to match the background to hide it.

Now you have actual cell values you can use and reference w/r to the state of the checkboxes.

Next I insert a ton of columns before each date column.  This technically isn't necessary as you could use a bunch of different conditional formatting formulas or write a more complicated formula but this keeps it 'easy' so I can make 1 pretty easy formula for OVERDUE, 1 for ALMOST DUE, and 1 for DONE

NOTE that I set BOTH the format for the fill color AND the text color so that TRUE/FALSE stays not visible

So in the above I show the 3 rules and you can see those extra columns I inserted and how the first row shows an example of FALSE (text not set to background), then RED because overdue, GREEN because checkbox done and YELLOW because almost Due.  NOTE those are the only 4 checkboxes I formatted the controls on.  In the attached I went ahead and hid some of the columns too.