If your transmission fluid looks milky, then very likely your car is having a faulty transmission system or perhaps a defective radiator. When a defective radiator passes coolant to the transmission system, then the fluid may look milky.