Conditioning a cell past 2 weeks

[katiapro93]

Hello everyone. Again, I am stumped. I have a spreadsheet that has a column for an end date. I need for the cell to turn a color when it is 2 weeks after the end date so that I know to ask for a report.

right now I have a condition in showing red because it is past the end dated and another one showing yellow when the date is within this week letting me know it is going to end this week. Now I need it to alert me so I get a report 2 weeks after the end date. Can any one help. Thanks.

 

[schielrn]

Maybe something like:

=enddate+14>=today()

or:

=today()-14>=enddate

Change enddate to the cell in reference.

Hope that helps.

 

[katiapro93]

AWESOME!!!! it worked. Thank you so much, you saved me alot of time and missed opportunities. Again, Thank you!