Mar 26 2020 11:03 AM
I am looking for conditional formatting formula that will highlight E2 since this stage gate 5 date is older than D2's stage gate 4 date. Ideally, I would like it to ignore blank fields as well since different project types don't require the date to be filled in.
I have the following data:
A | B | C | D | E |
4/15/19 | 12/10/19 | 3/13/20 | 4/3/20 | 12/27/19 |
4/15/19 | 6/13/19 | 2/10/20 | 4/17/20 | 5/18/20 |
4/15/19 | 2/24/20 | 4/30/20 | 8/28/20 | 9/30/20 |
2/14/19 | 12/20/19 |
I've tried variations of =$E$2<$D$2. I've also tried the date formatting, cell data between criteria etc.
Mar 26 2020 12:49 PM