+ Reply to Thread
Results 1 to 2 of 2

Not sure if this is beyond Excel or not?

  1. #1
    Registered User
    Join Date
    09-19-2007
    Posts
    9

    Not sure if this is beyond Excel or not?

    My goal is to get the file where everytime you open it, it compares the current date to the date within that particular cell. For example if cell B2's due date is 05/13/08 and you open the file on 05/14/08, it would automatically turn cell B2 red. Is this even possible in Excel?

    I really do appreciate any information anyone can offer.
    Attached Files Attached Files

  2. #2
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676
    You can use conditional formatting for this.

    Assuming your "trigger date" [e.g. 1/1/2009] is in cell A1 then select cell to be highlighted, i.e. B2, and use

    Format > Conditional formatting > "formula is"

    =TODAY()>=$A$1

    select red format, OK

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1