I have 4 cells. Below is what I am trying to accomplish. I need the formulas
for each of the conditions. Please help.

Condition for Cells 1-3
Condition 1: If date is greater than NOW() - Red
Condition 2: If date is less than NOW() - Green
Condition 3: If there is a date in cell 4 (over ride conditions 1 and 2) -
Blue

Condition for Cell 4
Condition 1: If there is a date in cell 4 - Blue

Thank you,

Aviator