How do I auto check a box based on a date + x # of days?

Can I get a box to auto check (so a conditional format is triggered) based on a date + 4 weeks? I want the sheet to auto tick a check box for me when something is 4 weeks past a specified date column. I want that to also correlate to another column that has a full harvey ball or % value of 100 or even just another tick box.

What I am trying to do is get a deposit date looked at against an all items received column and then check a box if its is past 4 weeks and the items have not all been received. This can then trigger a conditional format to change the row to bold red or something simialr to draw attention to it.

Is this possible and what would the formula be?

Find more posts tagged with

Sales

Formulas

Conditional Formatting

Project Management

Comments

SmSulli

Steve,

In the column with the checkbox you can use an =IF statement. Check = 1, Not Checked = 0.

Example:

=IF([Date]1 + 28 < Today(), 1, 0)

Then you can set up your conditional formatting.

Good Luck

Shawn