Custom Data Validation Message! ⚠️ There are three tabs that you need to know about when working with Data Validation (Settings, Input Message, and Error Alert). The Settings tab is used to set the allowed values for the selected cells. The Input Message tab is used to show a small pop-up message with guidance for what values are allowed to be entered. The Error Alert tab is used for restricting invalid data: Stop = Completely prevents invalid data from being entered. Warning = warns the user but allows the rule to be bypassed. Information = notifies the user of invalid data but allows it to stay. ❤️ and follow for daily tips! 🗂️ Save this post for future reference! 👯 Share it with a friend! 🎁 Get Excel Templates, PDF Cheat Sheets, Trackers, and Trainings at the link in our bio! 🎯 Follow us on Instagram, YouTube, TikTok, and more at the link in our bio! #excel #shortcuts #cheat #sheet #spreadsheet