SOLVED

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

Copper 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

@SpaceAge 

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 (Copper Contributor)
Solution
Thanks, Hans.
I finally got around to trying your solution, and it worked perfectly!
Regards,
Vince
1 best response

Accepted Solutions
best response confirmed by SpaceAge (Copper Contributor)
Solution
Thanks, Hans.
I finally got around to trying your solution, and it worked perfectly!
Regards,
Vince

View solution in original post