Excel: Conditional formatting depending on the date - how it works
In Excel, you can format a cell depending on the date. With the conditional formatting, one or more cells can be provided with a desired color or with effects. We show you how to do it here.
Excel: Conditionally format cell with date
You can format a cell with a date quickly and easily:
- Select the cell and click Conditional Formatting on the Home tab.
- Under "Cell Highlighting Rules, " select "Date."
- Now you can set a rule and choose a default formatting or set a custom format.
- If you want to define several rules for a cell, click on the cell and select "New rule" under "Conditional formatting".
- Then click on "Format only cells that contain" and select "Date". Now you can define another rule with the appropriate formatting.
On the next page we will show you how to only allow certain values in Excel cells.