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 :)


--
Walt Matchim
------------------------------------------------------------------------
Walt Matchim's Profile: http://www.excelforum.com/member.php...o&userid=26885
View this thread: http://www.excelforum.com/showthread...hreadid=401167