Hello,
I've got some data where I want to compare two dates and highlight the cell if the second date is three years older than the first date.
For example:
Last Active Info Submitted 08/07/2015 14/02/2015 23/05/2015 14/02/2015 23/05/2015 06/10/2010 15/08/2014 28/06/2012
The cell with 06/10/2010 would be highlighted due to the date being three years older than 23/05/2015 but the other two dates wouldn't as they are less than three years older than the first date.
Any help would be much appreciated.
Bookmarks