You can't import reminders from outlook calendar, but you can operate directly in excel to set the reminder function. The operation method is as follows:

1. First, open a sample table, and here I will randomly create a data table with contract expiration as an example.

2. Let's set this form to be automatically reminded 3 days before it expires.

select the F2: F8 cell in the table and click the conditional formatting button under the start panel menu.

3. after clicking the button, select the management rule option in the pop-up drop-down menu.

4. in the rule manager window, click the new rule button.

5. in the new format window, click and choose to use formula to determine the cells to be formatted.

6. enter =AND($F2> TODAY(),$F2-TODAY()< 3), and then click the format button below, in the pop-up window of setting cell format, click the Fill tab, set the color to red (you can also set other colors according to your preference), and finally click OK.

7. finally, click ok in the new rule window, and then click apply in the manager window to confirm the button.

8. At this time, there is no record of contract expiration in the form, and there is no reminder. Add a record to test the setting effect, and add a record for November/October, 214.

9. if you want to change the reminder time, you can modify the formula =AND($F2> TODAY(),$F2-TODAY()< 3 in 3); $F2 means to retrieve any row of column F in a fixed way; > TODAY () stands for excluding expired contracts before the system date; $F2-TODAY()< 3 means that the difference between the contract date and the system date is less than 3 days.