Home » Forums » Open Source Learning Center » Question and Answer

if/then conditional formula

Submitted by stapoler on 20 January, 2016 - 18:23

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!

‹ Excel VBA - 3 numbers,greater,smaller or equal logic What formula to use ›
»

Hi Stapoler, Assuming the

Submitted by mec1981 on 21 January, 2016 - 03:33.

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

Submitted by stapoler on 21 January, 2016 - 21:01.

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()

Submitted by mec1981 on 25 January, 2016 - 05:51.

Hi Stapoler

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

»