Do you need to check on how many characters and/or numbers have been entered into a cell in Excel. This can be really useful for validating entries. Something like checking that the correct amount of numbers have been added to a credit card is one example as there are always 16 numbers in the long number. I also show you how to highlight any that may stand out using an IF function as well as conditional formatting. There are links to tutorials on how use them in more details below. Gary Schwartz from http://www.jargonfreehelp.com shows us how.
Works in all versions of Excel on Windows or Mac.
Related video tutorials:
Conditional formatting Part 1: • Excel: Conditional Formatting to High...
Conditional formatting Part 2: • Excel: Conditional Formatting to High...
Using formulas in conditional formatting: • Excel: Using Formulas in Conditional ...
Using the IF function: • Excel 2003: IF Function
Смотрите видео Excel: Using the LEN Function онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь jargonfreehelp 29 Январь 2019, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 465 раз и оно понравилось 6 людям.