If I have a column contains a due date, and I need to format to be red if this dates exceeded.
Hi Steve, Yes I am aware to use the Format Rules, my doubt about the formula…
If the column is named (Due Date) and I need the formula to show that if the due date exceeded
I tried [Due Date] > Today() it is not allowed
Please post a screenshot of the error.
Dear Steve, I tried to put the formula as shown
[Due Date] = TODAY()
It is now working prefect … the date turned into red color as formatted.