How to Highlight This Week's Date in Google Sheets with Conditional Formatting
Learn how to highlight dates for the current week in Google Sheets using conditional formatting. This tutorial covers applying custom formulas and adjusting formatting for entire rows.
I have a bunch of dates, and I want to only highlight this week's dates, or these projects that are starting this week. How do I do that? I will show you in this video. We're going to go up to Format , Conditional Formatting . We're going to apply the range A to A. We're going to format these cells rules as custom formula . We're going to equals WeekNum, N U M, A, 1, in parentheses, is equal to Week num, and we're going to wrap that around today with parentheses as well. You'll notice the only two dates that are highlighted are this week's dates. We can change the color here. Maybe we want to change it to bright yellow and click done. If you notice third and the sixth are this week, but what if we want to highlight the entire row ? Rishabh Asks: Conditional Format Whole Row Via Text inside a Cell Organize Your Data! - Build a Kanban Board / Trello Board Highlight Row as You Move Your Cell Selection How To Highlight Any Date One Week In Future
We're going to change this. Apply to range , A to C. And we need to, in our custom formula , add a dollar sign in front of the A. That way it will look at the A column no matter which column it's in, and see the entire column is highlighted when it is this week. Click done. You can also change that color if you wish. If you're looking to get more out of your Google Sheets than you have before, subscribe here to BetterSheets on YouTube. Ultimate Checklist in Google Sheets The Simplest Bestest Checklist in Google Sheets Now Do It Every Damn Day - Learn to Code in Google Sheets Part 5 How to Change the Color of a Cell