If you type the =Today() function in any cell and press Enter, Excel will show you the current date. Therefore, this method is used to highlight the rows with dates earlier than the current date.

In Microsoft Excel, borders are lines that form around a cell. In Excel, there are options to add both predefined cell borders and custom cell borders. Click on a cell in the worksheet.