Download Excel File: https://excelisfun.net/files/EMT1766.xlsx
Learn how to.
1. (00:00) Introduction
2. (00:38) Why we build formulas in cells before pasting formula into Conditional Formatting Dialog Box
3. (01:19) Logic for formulas to find missing numbers in the incident number
4. (02:09) Create formula to find next sequential number from a text string. Learn about “Text Numbers” and Actual Numbers
5. (03:34) Create formula to check if NEXT number is in sequence
6. (05:14) Create formula to check if PREVIOUS number is in sequence
7. (06:46) What is an OR Logical Test?
8. (07:17) Clipboard to collect formula elements using keyboard Ctrl + C, C
9. (08:04) OR Function for Logical Text
10. (08:41) Mixed Cell References for formula to conditionally format whole row
11. (09:34) Paste formula into Conditional Formatting Dialog Box
12. (10:18) Test Conditional Formatting
13. (10:29) Summary
14. (10:50) Closing and Video Links