If you want to highlight cells that are in the current week, use Conditional Formatting to help out. Conditional Formatting is a general term that means cells are formatted based on certain conditions. Excel has a default setting to highlight cells based on a relative date reference. Use this if you want to highlight when invoices are coming due, like in this example. You can also create a custom formula using Conditional Formatting and the TODAY function. But the option in this video is much si

Excel: Conditional Formatting

Excel Conditional Formatting Advanced Technique

Conditional Formatting with Color Scale using Google Sheets