Then, right-click on the date/time cell and select the Number Format option from the context menu. Once the window is opened, switch to the Date tab. Here you can find numerous options for dates.

Now it’s time to add the conditional format. How to add the conditional format in Excel Once you have a PivotTable, you’re ready to add the conditional format.