How to remind employees of their birthdays using EXCEL

Use EXCEL conditional formatting to change the color of the arriving name to remind employees of their birthdays:

1. Open the employee birthday statistics table

2. Select the employee's birthday All cell ranges of table data;

3. Click [Start]-[Conditional Formatting]-[New Rule]

4. The [New Rule] dialog box will pop up:

1. Click [Use formula to determine the cells to be formatted]

2. Enter the formula =AND(ABS(DATE(YEAR(TODAY())), MONTH($B2) in the formula box ), DAY($B2))-TODAY())lt;=3, MONTH($B2)=MONTH(TODAY()), DAY($B2)gt;DAY(TODAY()))

3. Click the [Format] button and set the conditional formatting shading to blue

4. Finally click the [OK] button

5. Use the EXCEL conditional formatting function to change the recent Employees whose birthdays are due within three days are clearly marked.