The Met Office has issued a yellow weather warning for Tuesday and Wednesday