if/then conditional formula

I'm trying to create an if/then conditional formula that highlights the cell if the date shown is greater than 7 days past the current date. Thank you!

Hi Stapoler, Assuming the

Hi Stapoler,

Assuming the cell with the date is C2, highlight C2 - next click on conditional formatting - select new rule - select "use a formula to determine which cells to format"

Then under "Format values where this formula is true" put the following:
=If((Today()-C2)>7,1,0)
then click on Format - click on fill tab name - pick a colour

Regards
Mark

Thank you Mark! Do you know

Thank you Mark! Do you know if there is any way to make it active so it changes based on the current date?

Hi Stapoler using Today()

Hi Stapoler

using Today() without any data in the bracket, will always use the current date on your computer