• 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

  • Assignment schedule1.xlsx
    122 KB · Views: 9
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