Excitement Builds as Rare Comet Lights Up the Night Sky