• 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.

Search results

  1. L

    Conditional Formatting relating to dates

    Hi there I'm attempting to set up a record of contracts via excel. I'd like to implement a cell that serves as a reminder for whether or not action should be taken depending on the date and end of contract date (ie more than 12 months left = green, 12 to 9 months left = amber, 9 - 6 months...
  2. L

    Using Timestamp Formula for Version Control

    Hi all Recently I was messing around with the timestamp formula (see Chandoo's article here: http://chandoo.org/wp/2009/01/08/timestamps-excel-formula-help/), and figured I could use it to help maintain version control on my project documents at work. The sheet documents the current version...
  3. L

    Issue Register - last 30 days' formula

    Hi all I'm attempting to create an issue register that will check the last 30 days' activity (open and closed) much like Chandoo's example. I have racked my brains and I cannot configure the formulas to track the last 30 days! I've uploaded the file - any advice is much appreciated...
  4. L

    SWOT Analysis

    Hi there I've set myself the goal of creating an awesome chandoo-esque SWOT chart in excel (Strength, Weakness, Opportunities, Threats) - anybody had any experience with this or know of any decent resources out there?
Back
Top