Forum Discussion
Bella A
Feb 26, 2018Copper Contributor
Changing the date colour when the date has past?
Hi, what is the function/formula to have a cell's text change colour when the date entered into that cell has past?
for example i have a sheet that has a list of staff names and the dates they ...
SergeiBaklan
Feb 26, 2018MVP
Hi Bella,
You may apply Conditional formatting with the rule like
=[your date] < TODAY()