Connie this is just what I did last week. First I had to scrape off the black paint, rather messy, with paint pieces falling in my face as I lay on my back inside the cabinet. The next day, after the fish had calmed down from losing their "substrate", I reached into the cabinet with my can of tan spray paint and just sprayed the glass. I used the sandy paint, with the texture, but wish I had saved $$ and just gone with plain cheap paint. Only the color shows, not the texture, as someone noted earlier in this thread. And be sure to wear a mask and have some windows open. I also covered up my air pump with a heavy towel to keep any fumes away from it. The fish were a bit nervous as their clear glass became tan, but within a minute or so their colors got lovely and they were enjoying their new substrate. I am so glad I did it! Let me know if you want more info.on the project.
Barbara