Formula to detect anomaly in data entered in excel sheet

I have an excel sheet used by an operator to enter details of fuel delivery for the fleet on daily basis.

The fleet is of over 100 vehicles and equipment's.

The problem I currently face is anomalies in data entry. The operators are making TYPO's while entry mileage/ODO meter of equipment.

Is there someway in which i can use excel to detect errors,

For example, If an operator enters a mileage of 145205 on Monday, the equipment refuels on Thursday, with mileage, 145225, but the operator enters 1452250.

I am also attaching the Sample sheet with a month data for Three equipment's.

The Column in shaded in yellow is the mileage column. Each equipment has a unique fleet number.

If you select cells E8:E84 and add a new conditional format, using a formula of:

=E8<MAX(INDEX($E$8:E8*($D$8:D8=D8),0))

And set that to fill the cells red then it will highlight any cells where the entered mileage is less than the previous highest entered mileage for that fleet number.

Would that help?

Thanks for your reply Andrew.

The Conditional Format initially works, but then the sheet goes into a loop of refreshing and crashes the software.

Ew, that doesn't sound good. Not sure why that's happening.

Is that the sort of thing you're looking for, though? Because we could also try a macro to check the same thing.

Here you go, with macro (which I'm sure I made far more complicated than needs be)

Thanks for your help