+ Reply to Thread
Results 1 to 3 of 3

Need formula to cancel conditional formatting when a date is entered in another column

  1. #1
    Registered User
    Join Date
    05-15-2014
    MS-Off Ver
    Excel 2003
    Posts
    15

    Need formula to cancel conditional formatting when a date is entered in another column

    I have two columns of dates where in the first column titled "Date reported Missing" if the date entered is past 30 days a conditional format highlights it red. In the next column titled "Date reported Found" when a date is entered I want the conditional format of highlighting the column "Date reported Missing" red to go away as this date indicates it as found. I need a formula for another conditional format to clear this out. I am attaching the file. Any help would be great, thanks in advance.
    Last edited by hbiglay; 08-19-2014 at 02:41 PM.

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Need formula to cancel conditional formatting when a date is entered in another column

    Change your CF rule to

    =AND($B2="",TODAY()-$A2>30)
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    05-15-2014
    MS-Off Ver
    Excel 2003
    Posts
    15

    Re: Need formula to cancel conditional formatting when a date is entered in another column

    You are so smart and awesome. It works great. Thanks. I will mark this as solved. Also, can you explain that formula to me so I can learn and understand it better.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 11-23-2013, 06:21 AM
  2. Conditional Formatting one column if another column has date entered
    By sunnyfield in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-27-2013, 11:08 PM
  3. Replies: 2
    Last Post: 10-09-2012, 03:57 PM
  4. Replies: 10
    Last Post: 10-07-2012, 04:50 PM
  5. Replies: 1
    Last Post: 05-06-2010, 12:08 PM

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