Now, let’s set a conditional formatting rule that highlights due dates that match the current date, which in this case is Feb. 13, 2021: Select the data. In this case, that’s C4:C8.

3] How to create a custom-made formatting rule with dates. In the above example, we navigated the steps for creating a New Rule for Conditional Formatting based on already provided criteria.Excel ...

Create a to-do list in Excel . First, you need to insert relevant details in your Excel sheet. In the example below, I will ...

You might track due dates, delivery dates, appointments and so on. Depending how you use these dates, you might want to highlight specific dates as they approach the current date in Microsoft Excel.