Tuesday, June 9, 2015

Birthday Reminder

Remembering an individual’s birthday can be very important.  It may seem like a little thing, but it can make a big difference in a person’s day if he or she feels remembered (True in both personal and corporate settings…).

With our old friend Excel, you can use a clever, and reasonable accessible formula to create a Daily Reminder of whose birthday it is on any given day.

Let’s say you have a list of 300 birthdays in Column A (A2:A301) which you (cleverly) name “Birthday” in A1, the corresponding First Name is in Column B, and Last Name is in Column C.  These may be the names of the employees at your company, (or maybe you have a really big family!).

Here’s What You Do:

1.    Select the entire range A2:C301

2.    Then go to your Home ribbon and choose: Conditional Formatting>New Rule>Use a formula to determine which cells to format, and enter:


4.    Click the Format button, select the Fill tab, and choose a color

Now, every time you open this workbook, Excel will automatically highlight the person (or people if more than one on any date) whose birthday is today.

You may never miss a birthday again!  (Your Mom would be proud…).

No comments: