Follow the steps below to set conditional formatting for dates within 7 days in Google Sheets.
Click and drag to select the range of cells that contain the dates you want to format. This could be a column or a row of dates, depending on how your sheet is organized.
Go to the top menu and click on Format. From the dropdown menu, choose Conditional formatting. This will open the Conditional format rules panel on the right side of your screen.
In the Conditional format rules panel, you should see the range you selected already filled in under "Apply to range". If not, you can manually enter the range or select it again here.
In the panel, look for the “Format cells if” dropdown and select Custom formula is. In the formula box that appears, enter the following formula:
=AND(A1<=TODAY()+7, A1>=TODAY())
Note: Make sure to replace A1 with the cell reference of the first cell in your selected range. This formula checks if a date is within the next 7 days from today.
Below the formula box, you'll see options for setting the format. You can choose a background color, text color, and other styling options to apply to cells that meet the condition.
Pick a color that will make these dates stand out. For example, a bright color like yellow or green can be a good choice.
After selecting your formatting options, click on the Done button.
Your conditional formatting rule is now set! Dates within the next 7 days from today in your selected range will be highlighted with the formatting you chose.
We hope that this article has helped you and given you a better understanding of how to apply conditional formatting for dates within 7 days in Google Sheets. If you enjoyed this article, you might also like our articles on how to switch to view-only mode in Google Sheets and how to swap columns in Google Sheets.
