Expand the drop-down menu and select Use a formula to determine which cells to format. Enter the formula or value (=TODAY () or =TODAY ()+7). Choose the formatting you want to apply.

Microsoft has been adding new features to Excel lately, and the latest one could change the way people work with formulas.

This article looks at how to use Excel’s auditing tools to audit formulas and ensure the accuracy of data.