I want help with excel date alerts

Copper Contributor

so  I want to put alerts for dates of expiration for passports and licenses 
when there is only one year left I want the colour of the cell to turn blue when there are only 6 months left I want the colour of the cell to turn green when there are only 3 months I want the cell to turn yellow when there is only one month I want it to turn red.
i want the exact step-by-step guide I tried ChatGPT guide but it's an old guide and most of the things he mentioned don't work anymore so please help me it's really urgent

1 Reply

@MR_Sami007 

In CF rule you may use formula like

=A1<EDATE(TODAY(),3)

for 3 months, etc.