I have an accumulative value (miles from odometer) entered into a different cell of a column daily. I would like to have the cell background to be highlighted in Red when the miles reach intervals of 500 or the next entry over. This would indicate that the vehicle reauires service.
Example: 220, 356, 512, 678, 876, 1024, 1344 ...
The cell containing 512 would be highlighted because it reached another 500 miles. Same with 1024.

Hope you understand. Please help.

Thank you

Walt