Hi Folks,

First post on the forum, so please forgive me if this problem has been addressed already (I imagine it may already have!)

I have cell f5 which displays the date of an invoice.

I want the following conditional formatting to be applied over a cell range if the following conditions are met:

If it has been more than 5 months since date in f5--> cell range colour fill red
If it has been more than 4 but less than 5 months since date in f5--> cell range colour fill amber
If it has been less than 4 months since date in f5--> cell range colour fill green

I have seen EDATE and TODAY functions but am struggling to get them to work across the three colours. Any help appreciated.

Thanks guys