Conditional formatting for a date based off of another cells date excluding blank cells

Highlighted
Occasional Visitor

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:

 

ABCDE
4/15/1912/10/193/13/204/3/2012/27/19
4/15/196/13/192/10/204/17/205/18/20
4/15/192/24/204/30/208/28/209/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.

1 Reply
Highlighted

@RRRaz 

That could be

image.png

with formula

=($E2<$D2)*($E2<>"")