I have a spreadsheet tracking multiple dates for about 150 people. I am having a problem however getting dates in Col I to highlight if they are going to be past the date in Col P.
I want Col I Row 4 & 5 to highlight. How do I write/do this? Everything I have tried so far has failed.
Col I Col P 06-JAN-2015 15-OCT-2017 01-AUG-2014 10-AUG-2019 17-JUN-2015 25-JUN-2015 10-DEC-2014 05-OCT-2014 - highlight 27-NOV-2014 10-JUL-2014 - highlight 01-JAN-2015 26-AUG-2016