Comet G3 ATLAS , first spotted in April, is expected to be so vibrant that it will rival the brightness of Venus in the night sky .