Dear sir/Madam,
is there any way where i can use excel to manage my daily work list and put reminder to the working list.
example 15th November 2022 I have to pay tax can put reminder using excel ?
Hi Sarfraz,
Yes, you can create a to-do list with Excel. You could use conditional formatting (lesson 5.13) to highlight due dates that are approaching, due or past.
You could also use Power Automate to remind you via email.
Mynda
Respected madam,
do you have any excel file ready where I can get conditional formatting for task highlight before 1 and on due date or overdue date task with different colors?
Hi Sarfraz,
I use that type of conditional formatting in my Project Management Dashboard. Here is a specific tutorial on just the Excel gantt chart portion.
Also see this lesson on conditional formatting with formulas for a thorough understanding of how they work in the background.
If you get stuck, come back here with your example Excel file so we can show you.
Mynda
