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.

You've already asked this here:
https://www.msofficeforums.com/excel...two-cells.html
I responded with a question or two but you haven't answered…

Thanks for pointing that out p45cal, I was wondering when the OP would notice our answers...

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post