Conditional formatting to provide colour coding for expiring dates

[Squelch87]

Hi all,

I have a dates set in Excel.

I need the following:

The expiry date is three years from the date in the cell. So for example, if the date reads 30/3/16 (it's expiry date is 30/3/19), that is out of date. If it reads 30/3/17 (it's expiry date is 30/3/20), that is in date.

I need my cells to show red if out of date, green if in date or orange if the expiry date is less than 90 days (3 months) away.

Is anyone able to help? I've now spent a number of hours trying to use multiple functions but I've failed

[saravnepali]

Try conditional formatting the cells

https://www.microsoft.com/en-us/micr...ates-in-excel/

[alansidman]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[Squelch87]

Is that better?

[AliGW]

Yes - thanks. Please take more care in future.