How do I validate data on entering it into a cell? I’d like to ensure that no value less than 5,000 is entered into the cells in a particular column. I have tried conditional formatting but have not found a way. It would be nice to give the user an error message too "You cannot enter a value less than $5,000). Thanks for the help.
There is currently no way to do data validation in cells similar to how this works in Excel and Google Sheets. However, you can flag cells conditionally using Conditional Formatting. More details here: