CF formula for red cells:
=AND(C4<>"",C4<TODAY()-730)
for blue cells:
=AND(C4<>"",C4>=TODAY()-730)