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
Bookmarks