IF statement in Conditional Formatting
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.
|