I think this is what you are looking for. Place this in the conditional
format as Formula Is and format to your desires. Change Cell reference
accordingly.

=AND(A1<"",INT(A1/5000)=(A1/5000))

Good Luck,
Les



"PDC" wrote:

I am putting together a spread sheet for tracking hours on equipment and want
excel to notify when a condition has been met. IE equipment needs
Preventative service at every 5000 hour mark( the hour meter does not reset
but contiues to mark time in hours. I want to be notified when that data is
entered, by the cell changing color or denoting text.(data will be entered by
other personal than myself)