Highlight missing sequential number

[SusanB1066]

How do I check for missing numbers is Excel? Current numbers should be sequential and I want Excel to tell me is there is a missing number.

[#2]

@SusanB1066 

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.

=IF(ROW($A2)>ROW($A$2),$A2-1<>$A1)

[#3]

@JMB17 

IMHO, more simple CF formula =$A2<>$A1+1 shall work.