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

%3CLINGO-SUB%20id%3D%22lingo-sub-1256468%22%20slang%3D%22en-US%22%3EConditional%20formatting%20for%20a%20date%20based%20off%20of%20another%20cells%20date%20excluding%20blank%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1256468%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20looking%20for%20conditional%20formatting%20formula%20that%20will%20highlight%20E2%20since%20this%20stage%20gate%205%20date%20is%20older%20than%20D2's%20stage%20gate%204%20date.%20Ideally%2C%20I%20would%20like%20it%20to%20ignore%20blank%20fields%20as%20well%20since%20different%20project%20types%20don't%20require%20the%20date%20to%20be%20filled%20in.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20the%20following%20data%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22500%22%3E%3CTBODY%3E%3CTR%3E%3CTD%3EA%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3EC%3C%2FTD%3E%3CTD%3ED%3C%2FTD%3E%3CTD%3EE%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2287%22%3E4%2F15%2F19%3C%2FTD%3E%3CTD%20width%3D%22101%22%3E12%2F10%2F19%3C%2FTD%3E%3CTD%20width%3D%22101%22%3E3%2F13%2F20%3C%2FTD%3E%3CTD%20width%3D%22101%22%3E4%2F3%2F20%3C%2FTD%3E%3CTD%20width%3D%22110%22%3E12%2F27%2F19%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E4%2F15%2F19%3C%2FTD%3E%3CTD%3E6%2F13%2F19%3C%2FTD%3E%3CTD%3E2%2F10%2F20%3C%2FTD%3E%3CTD%3E4%2F17%2F20%3C%2FTD%3E%3CTD%3E5%2F18%2F20%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E4%2F15%2F19%3C%2FTD%3E%3CTD%3E2%2F24%2F20%3C%2FTD%3E%3CTD%3E4%2F30%2F20%3C%2FTD%3E%3CTD%3E8%2F28%2F20%3C%2FTD%3E%3CTD%3E9%2F30%2F20%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2%2F14%2F19%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E12%2F20%2F19%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20tried%20variations%20of%20%3D%24E%242%26lt%3B%24D%242.%20I've%20also%20tried%20the%20date%20formatting%2C%20cell%20data%20between%20criteria%20etc.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1256468%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1256766%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formatting%20for%20a%20date%20based%20off%20of%20another%20cells%20date%20excluding%20blank%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1256766%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F596772%22%20target%3D%22_blank%22%3E%40RRRaz%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20could%20be%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20523px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F179811i9552AC3216ACF6DE%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Ewith%20formula%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3D(%24E2%26lt%3B%24D2)*(%24E2%26lt%3B%26gt%3B%22%22)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
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<>"")