Highlight Dates with the help of Conditional Formatting

Super Contributor

Hello Everyone,

 I would like to know how to have a cell change colour as it approaches an expiry date, for example, the expiry date is 23-Sep-21..from the 23-Jul-21 the cell is green...23-Jul-21 to 23-Aug-21 it becomes yellow and then from the 23-Aug-21 to the expiry date of the 23-Sep-21 the cells turns red. so, as the date changes the cell colour changes with it.

Can you please explain with example that what formula should i write in Conditional Formatting? 


2 Replies
best response confirmed by allyreckerman (Microsoft)

@Excel Perhaps like in the picture below.


Screenshot 2021-05-16 at 09.07.50.png

It worked! Thank you so much sir