I have a spreadsheet where I record employees time clock punch in and punch out times. Occasionally I will have a typo where I enter 8;00 instead of 8:00. This creates a problem in another part of the workbook that is dependent on this data. I'm looking for a way to flag this so I know it is an error. Maybe with conditional formatting where the color changes. Any other method may work; I just need it to stand out.
Thanks,
Tom
Thanks,
Tom