Formuale to track numbers sequence, change the colour of the font

Hi All,

1.) Is there a forumale in excel to detect and count to track a list of sequemce numbers. Eg:

00001
00002
00004
00005

No of Records not in sequence : 01


2.) Is there any formuale to change the colour of font if the font display a "WRONG" text ?


Please help
Thank you.