I'm assuming at this point you aren't using "Remap tile set palette" and your set has a working palette. If so, the solution is relatively simple. Just make the color you want to be transparent the second entry in the palette, and make sure the first entry is #000000.