Conditional Formating with Date Stamps

[dharmalife87]

I need to know if new entries are made within the last 7 days. I do not need the date posted to my viewing just a highlight in my choosing of color. I only want the conditional format to last 7 days then it can go away to normal format. Is this possible or is there an alternative function available to solve same problem??

 

[BrianMH]

Set your conditional formatting formula to be =A1>=today()-7 assuming A1 contains the date.

 

[dharmalife87]

Set your conditional formatting formula to be =A1>=today()-7 assuming A1 contains the date.

Nothing has the date actually on it. We have no need to know when the changes are made in the long run. I do need to know when recent changes are made so I can review them.

 

[BrianMH]

Well if you don't record the date the change is made you can't know if it is in the last 7 days.

 

[dharmalife87]

Well Darn! that will be too much work to ask for people. Thank You for your time