Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2006
    Posts
    14

    Unanswered: Change text based on another cell's condition

    Hi there,

    In the attached sample.xls, I have three column headings

    1 Due Date
    2 Closed Date
    3 Status( has Data Validation List of "Open", "Closed" and "Overdue")

    I want to do the following.

    If Due Date is a day in the future and corresponding Closed Date field is empty or blank....I want Status to show as "Open"

    If Due Date is past due(<Today()?), and Closed Date field is blank, Status to show as "Overdue"

    If Closed Date field has a date entry, then Status to show as "Closed"

    Any suggestions?

    Nate
    Attached Files Attached Files

  2. #2
    Join Date
    Aug 2006
    Posts
    14
    Typo in above post

    If Due Date is past due(<Today()?), and Closed Date field is blank, Status to show as "Overdue"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •