Create A Task Reminder In Excel

We are tend to forget some the stuffs that we are required to do in our offices or in our day to day life for example stuffs to pack before leaving for a holiday etc.

Let’s see how to create a simple daily task reminder in excel.

We will see how we can create a task reminder in excel to organise our day to day work with the help of simple formula in conditional formatting.

Below we have the predetermined list of work along with their dates. We want to highlight the tasks that are due for today i.e. June 28th 2016.

Capture




Step 1

Select the entire A and B column data to apply the conditional formula

Capture

Step 2

Go to New Rule under Conditional Formatting.

Capture

Step 3

Select “Use a formula to determine which cells to format” and enter the formula =B2=TODAY() in the formula box and choose the color with which you want to highlight the task by using Format button.

Capture




Press OK and you are done with the task reminder in excel.

Hope this helped.

 

Share The Knowledge

Random Posts

  • Free Download Excel GST Invoice

    Below is the link to download Excel GST Invoice Template. What are the specific mandatory fields in an GST compliant […]

    Share The Knowledge
  • Extract Substring Between Parenthesis In Excel

    get substring between the bracket in excel, excel formula to get value from within parenthesis, get numeric value from inside bracket in excel, get data from within bracket in excel

    Share The Knowledge
  • Create Comma Separated Values From Excel Range

    create comma separated values from a range in excel, create comma separated string from a column in excel, VBA to create comma delimited values from a range or column

    Share The Knowledge
  • Hour From A Time In Excel

    Let’s see how to get the hour from time in excel. Hour () formula in excel returns a number from […]

    Share The Knowledge

Leave a Reply