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.
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.