Conditional formatting to represent a value when reached

[PDC]

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)

 

[WLMPilot]

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]

Thank you for your input. I was not able to get that formula to work. Jack
AKA PDC.

 

[WLMPilot]

I checked the formula before I posted it. Not sure what to tell you.

Sorry,
Les