Rare red weather warnings are in force for two popular holiday destinations in Spain