Highlight Row if column is "true" and date is 7 days greater than....

Rose17

Access 2007... I am creating a report tracking spreadsheet. Basically consists of a column of report numbers (column A) and then different locations that report may be sent to with a checkbox column... if checked, the column next to it displays date it was checked. I would like to highlight a row if the report has not been "checked" as filed withing 7 days of the first check mark.... first check is D2 (check mark) with date populating in E2. "Filed" column is X2 for check mark and Y2 for populated date.  Time clock would only start ticking if a date is added in E2 and there is not a file date (or checkmark) in X or Y2.  I have gotten parts of formulas to work but nothing close to what I need. thanks for any help.  

Shaine Greenwood

Hi Rose,

This community site is specifically for Smartsheet (https://www.smartsheet.com) related questions. It appears that your question is only pertaining to Microsoft Access 2007, so you may not get the answer you need here.

I'd recommend that you try the Access community: https://support.office.com/en-us/article/Ask-the-Access-community-a466ebfb-6b1f-446e-b85c-33b0d07e2fbe

You're welcome to reply with any Smartsheet related questions.

Rose17

Thank you, sorry.