SEE: Explore these 87 Excel tips every user should master. Let’s add a conditional format that always highlights the current date: Select the cells or rows you want to highlight.

You’ll see the Edit Formatting Rule dialog box, where you can edit the formatting specifics of the currently selected rule. You can also change the cells the rule applies to by clicking the up ...