I have seen the other replies and not sure how they work, though they may be
exactly what you are looking for. However, I thought I would give another
By using conditional formatting, you can have a list of people (usually
listed from top to bottom in a spreadsheet) and indicate different events, ie
birthdays, anniversarys, etc. For purposes of this example, I am going to
reference cell C1 as the cell having an anniversary date and column C as the
column with anniversary dates of several people.
1) Click on cell C1
2) Click on FORMAT on the menu bar, then CONDITIONAL FORMAT
3) A window will pop up. On the left side of this window you will see ELL
VALUE ISwith a down arrow. Click on down arrow and change to FORMULA IS.
4) In the box to the right of FORMULA IS, type or paste the following formula:
=AND(C1>>€ MONTH(C1) = MONTH(TODAY())).
5) Click on FORMAT within the conditional format box and set up how you want
the cell to format if condition is true. Example: Have a BOLD WHITE font
with a RED BACKGROUND.
6) Click OK when finished
The following directions will paste the conditional format in C1 to the rest
of the column.
1) Click on cell C1
2) Click on the paintbrush icon located on the toolbar
3) Move mouse pointer to cell C2. Press and hold the left mouse button
while on C2, then scroll down, staying in same column until you have reached
the end of the list. If you scroll past the end of the list, it will be fine
in the event you add people later, the conditional formatting will already be
4) Release the button at whatever point you wish to stop pasting.
If you need an explanation of the formula I gave, let me know.
> Hello group,>
> Is it possible to have a pop-up window that reminds me of a birthday or >
> anniversary etc. I realize Outlook can do this for me but I'm in sales and I >
> have a spreadsheet with a customer database and sales tracker. It would be >
> convenient to have that all in one spreadsheet. I'm not an expert in excel >
> yet, can anyone point me in the right direction?>
> Digital2k >