Results 1 to 10 of 10

Condtional formatting based on dates

Threaded View

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

    Condtional formatting based on dates

    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. Or is this a VBA task?
    Attached Files Attached Files
    Last edited by rz6657; 02-16-2013 at 05:49 PM.

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