Dec 27 2020 04:03 PM
Dec 27 2020 10:55 PM
You could use a formula in either a helper column or conditional format. Say your data is in A2:A10 (A1 is a header), then try this formula in B2 and copy down. Or, you could select A2:A10 and use the formula in conditional format to highlight non-sequential entries.