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 colu...
- Thanks, Hans.
I finally got around to trying your solution, and it worked perfectly!
Regards,
Vince
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