Jan 24 2022 02:29 PM
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?
Jan 24 2022 02:46 PM
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.
Jan 30 2022 08:36 PM
SolutionJan 30 2022 08:36 PM
Solution