| Let's say you're doing a project
with a start date, a few milestones and have a deadline to meet. You
wished to be warned if the present date is greater than the deadline,
i. e. you are behind schedule.
You can write VBA code or you can use the standard features in Excel to
perform the job. Both the solutions are described here.
The range Q3 or cell Q3 contains the function '=TODAY()' which gets
today's date from the computer system. Therefore it's important that
your system date is correct.
In VBA we use the sub 'worksheet_calulate()' and the code almost
resembles the If function that we use under standard working
Without VBA we use the IF and TODAY functions of Excel to compare two
dates and based on the result we do a conditional formatting to create
our warning system.