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.
Bookmarks