Below is the formula I've used but it seem not to be working. Please help....

Use a formula to determine which cells to format

Red color

=OR( DATEVALUE(MID(A1,2,SEARCH(")",A1,2)-2)) < TODAY(), DATEVALUE(MID(A1,SEARCH("(",A1,2)+1,SEARCH(")",A1,2)-2))< TODAY() )

Use a formula to determine which cells to format

White color

put a check mark if Stop If True

=ISBLANK(A1)=TRUE

Format only cells that contain

red color

Cell value >>> greater than >>> =NOW()+1825

Format only cells that contain

Yellow color

Cell value >>> greater than >>> =NOW()+1460