The invention relates to a sand-containing colorful environment-friendly coating and a preparation method of the same. The coating is composed of a pigment component, a dispersion medium and varnish; the pigment component includes RO water, cellulose, a dispersant, pigments and fillers, a defoamer, a film forming additive, an emulsion, an anti-freeze agent, an inorganic protective glue solution, a pH regulator, a sterilizing agent, a first thickener, and natural colorful sands; the dispersion medium includes RO water, the film forming additive, a rheological agent, the emulsion, an organic protective glue solution, the defoamer and a coupling agent; and the varnish includes RO water, the emulsion, the pH regulator, the sterilizing agent, the defoamer, the film forming additive, the anti-freeze agent, and a second thickener. Compared with the prior art, the sand-containing colorful environment-friendly coating has good storage and construction stability, wherein a dried film of the coating is excellent in adhesion force and water resistant performance. The coating, when being used, has a good rough sense and has clear layer sense, thereby representing a texture effect of natural stone materials better.