The Met Office forecast the effects of a coronial mass ejection – a burst of material from the sun into space – would result in the colourful displays across northern parts of the UK from Tuesday evening