Changing the color of the text in a cell after a certain date

New Contributor

Is there a way to have excel change the color of the date in a cell from black to red once that date has arrived? So, for example, if there is a deadline of Feb 1, 2022, the date in the deadline column would be black. Once that date has passed, the test should turn to red. 


Can that be done?

2 Replies


Select the cell or cells you want to color.

Black (Automatic) will be the default font color.

On the Home tab of the ribbon, select Conditional Formatting > New Rule...

Select 'Format only cells that contain'.

Leave the first drop-down set to 'Cell Value'.

Set the second drop-down to 'less than'.

Enter the formula =TODAY() in the box next to it.

Click Format...

Activate the Font tab.

Select red as color.

Click OK, then click OK again.

best response confirmed by SpaceAge (New Contributor)
Thanks, Hans.
I finally got around to trying your solution, and it worked perfectly!