The present invention discloses a coating with characteristics of a ceramic color and quartz sand texture, a preparation method and an application thereof, wherein the coating is prepared from the following components, by weight, 18-25% of an acrylate emulsion, 60-70% of color quartz sand and marble sand, 0.5-2% of a film forming additive, 0.1-1% of a thickener, 0.01-0.1% of a wetting agent, 0.05-0.3% of a dispersing agent, 0.5-2% of an additive, and the balance of deionized water. The coating of the present invention does not provide harm for human body and environment, and belongs to a green environment protection product. According to the present invention, based on the traditional texture coating, a high quality aqueous pure acrylic resin is adopted as a base material, and color quartz sand and marble sand are adopted to replace color paste to carry out color adjustment, such that the resulting coating film has characteristics of good flexibility, good bond strength, high hardness, ceramic-like color, nature, simplicity, and good color retention.