Results 1 to 4 of 4

Conditional Formatting based on dates (2)

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-15-2006
    Location
    USA
    MS-Off Ver
    Office 365, 64 bit
    Posts
    372

    Conditional Formatting based on dates (2)

    The attached file has a planned (PLN) and actual (ACT) dates.

    For the planned dates (PLN), I have a conditional formatting formula that highlights the cell when the date is within 20 days of expiring / passing. However, once the date expires (i.e. PLN date = 2/14/13 and TODAY date is 2/15/13), the cell will no longer highlight the cell.

    I need a formula that will highlight the cell even after the date expires AND the actual date has not been updated (adjacent column of each PLN | ACT date(s)). Once the actual date is updated in the corresponding cell, than no longer highlight. I've tried conditional formulas but can't find one.
    Attached Files Attached Files

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