We want to highlight last week's dates. For example, we have these projects that we're starting this week, but we want to just double check, is last week's completed? Let's highlight last week's dates. We're going to go up to Format , Conditional Formatting . We're going to apply a colon a, and our format cells rules is going to be a custom formula . We're going to equals WeekNum. We're going to wrap it around a 1. We're going to say, is it equal to weekNum today? And this shows us, or highlights, this week's dates. But we want last week's. So we just take weekNum today and minus 1. And now we have weekNumber matching of today minus 1 matching with A1. Project Based Task Management How To Highlight Any Date One Week In Future

So we see this is last week's. We can click done and have it just highlight the dates but we can also apply it to the entire range and apply a dollar sign in front of the A so it highlights the entire row . Click done and there we have last week's dates highlighted. If you're looking to get more out of Google Sheets and make better Google Sheets, subscribe here to BetterSheets on YouTube. Google Sheets Interface Changes Google Sheets Interface Changes Better Sheets Videos Checklist How To Highlight Any Date One Week In Future