Highlight cell based on custom formula of conditional formatting-CodePudding

I will input numbers serially but not in consecutive cells, it would be random like this:

I want to highlight numbers from where the serial number is broken as shown (Since number 17 is missing so number 18 onwards all number are highlighted)

Please help me with a custom formula for the conditional formatting of this.

CodePudding user response：

try:

=A2>INDEX(MAX(IFERROR((SEQUENCE(MAX(A$2:A))=SORT(A$2:A))*SEQUENCE(MAX(A$2:A)))))

update:

=REGEXEXTRACT(A2&"", "\d ,?")*1>INDEX(MAX(IFERROR((SEQUENCE(MAX(A$2:A))=
 SORT(UNIQUE(FLATTEN(SPLIT(A$2:A, ",")))))*SEQUENCE(MAX(A$2:A)))))