Forum Discussion
Solved
Changing the color of the text in a cell after a certain date
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?
- Thanks, Hans.
I finally got around to trying your solution, and it worked perfectly!
Regards,
Vince
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.
- Thanks, Hans.
I finally got around to trying your solution, and it worked perfectly!
Regards,
Vince
