=DATEIF(F2,TOAY(),"m"<=47  THE CELL TURNS NO COLOR
=DATEIF(F2,TOAY(),"m">57   THE CELL TURNS RED
=DATEIF(F2,TOAY(),"m">54   THE CELL TURNS PINK WITH RED WRITING
=DATEIF(F2,TOAY(),"m">48   THE CELL TURNS YELLOW
=DATEIF(F2,TOAY(),"m">48   THE CELL TURNS GREEN

=IF(ISBLANK(F2),0,(DATEDIF(F2,TODAY(),"m")<=47))