Get the most from your Mac! The show features news, tips, tricks, techniques, tutorials and reviews geared toward the casual, home and business Apple user. Covers the Mac, iPad, iPhone and other Apple products.
https://macmost.com
Guide Users To Enter Correct Values Into Numbers Spreadsheets (MacMost #1968)
View in HD at . If you are designing a Numbers spreadsheet to give to users that allows them to enter values then you may want to prevent them from entering values outside of a range. You can use conditional highlighting to change the color or style of a cell if the user enters a bad value. You can use a formula in another cell to indicate a bad value, plus instructions. You can also use sliders, steppers and pop-up menu cell formats to limit values.