The Met Office issued the warning late on Sunday night (March 9)