Celestial Transformation is a Quick-Play Spell Card.
Spell Cards are usually activated from the hand on your turn unless their type gives another timing window.
On the current TCG and OCG Forbidden & Limited lists tracked here, Celestial Transformation is Unlimited.
YGOPRODeck lists Celestial Transformation for these formats: Duel Links, Common Charity, Edison, TCG, OCG, Master Duel.
A listed print of Celestial Transformation appears in Dark Revelation Volume 4 (DR04-EN224) at Rare rarity.
Among markets shown on this page, the lowest listed snapshot for Celestial Transformation is about $0.13 on TCGPlayer (prices change frequently).
