Excel 表格如何設置時間提前提醒，並且變化顏色

想要一個生日提醒對吧？ =IF(AND(MONTH(A1)=MONTH(TODAY()),DAY(A1)=DAY(TODAY())),"今天過生日哦！",IF(AND(MONTH(A1)=MONTH(TODAY()),DAY(A1)+1=DAY(TODAY())),"只差一天過生日哦","")） excel到期提前兩周提醒

www.360doc.com