🎨 Alternate Row Colors in Excel Skip the Ctrl T. Use conditional formatting with a smart formula to color rows—automatically, as you type. ✨ Want more Excel tricks that go beyond the basics?👇 📥 Get free Excel templates training straight to your inbox Join 100K Excel pros leveling up every Tuesday and Saturday. 👉 excelforfreelancers.com/op/be-part-of-our-excel-community | Excel For Freelancers

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 sim