• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

figuring out a template

L

Lawrence429

New Member
so I downloaded the attached file as a "to-do" checklist and I cannot for the life of me figure out how the "HIGHLIGHT ASSIGNMENT DUE WITHIN" (Assignment Schedule tab) section works (it is really cool but I cannot find how it is connected to anything). Also any thoughts on why they configured the "Due On" column the way they did?
thanks for your help
Lawrence
 

Attachments

Highlight Assignment Due within is Conditional Formatting. The formula they used in it says
Code: 
=(CheckBoxRule)*($F7<=TODAY()+DateCheck)*($F7>=TODAY())

So I assume that CheckBoxRule is the cell that has the month dropdown which they've turned into a named range. DateCheck is also a named range but they've used a formula in it to make it vary its value.

Due On is just a random calculation. Its not really that important. It will change every day because they are comparing to current date & adding formulated value on top, rather than actual specific deadline. Sample data.
 
You must log in or register to reply here.
Back
Top