Results 1 to 8 of 8

Thread: how to formating automatic display of expired, open or closed

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Seeker bustos1juan's Avatar
    Join Date
    Mar 2019
    Posts
    7
    Articles
    0
    Excel Version
    2016

    how to formating automatic display of expired, open or closed

    Hello dear excel gurus. I hope this message find you well.
    I do not konw at all how to resolve or to figure out my doubt. I would like that my excel cell "STATUS" shows automatically the words "Expired, Open or Closed" dependind on the information included on the cell "Deadline".
    Please, see the attachement. I have two main colums "Date Assigned", "DeadLine" and "STATUS". I would like that the cells under the column "STatus" shows automatically the words "Expired, Open or Closed" dependind on the information included on the cell "Deadline".

    Thanks in advance for you support on this issue.
    Jhon

Posting Permissions

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