Highlight due dates this week in Excel with conditional formatting #workhacks #excel #exceltips

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 simpler.