I have successfully added the following formula to create "warning flags" in cells to indicate time left to an application deadline:

=$A2-TODAY()>90
=AND($A2-TODAY()>=61, $A2-TODAY()<=90)


=AND($A2-TODAY()>=31, $A2-TODAY()<=60)
=AND($A2-TODAY()>=0, $A2-TODAY()<=30)

Respectively colored Green, Yellow, Orange, and Red.

Another column (say D) is used to enter the date the application was received.

I would like to include (what I am assuming is) an IF statement that would override the initial instructions and color the cell in Column A Blue IF there is a date entered in the same row in Column D.

Thanks.