Combining OR and IF with Conditional Formatting

[aragno]

I am trying to accomplish the following.

I have date and times in cells A1, B1, C1, D1
A1 = 2014-Mar-01 20:30
B1 = 2014-Mar-02 00:06
C1 =
D1 = 2014-Mar-03 17:00
E1 = 2014-Mar-03 18:00

I am seeking a conditional format that would format cell D1 if D1 is less than C1, B1, or A1, but NOT format if C1, B1, or A1 is empty.

I feel like I need to combine both IF and OR to make this happen but I can't figure out the structure.

 

[konew1]

You need to include AND function
maybe
=AND(OR(D1< A1,D1< B1,D1< C1),AND(A1< >"",B1< >"",C1< >""))

Remove the spaces after "< " signs then test it and check
Cheers

 

[Special-K99]

Select D1

Conditional Formatting
New Rule
Use a formula to determine...

=(AND(D1 < C1, D1 < B1, D1 < A1, C1 < > "", B1 < > "", A1 < > ""))
format as required

Use Format painter to copy to other cells