Conditional formatting to represent a value when reached
 

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)

Conditional formatting to represent a value when reached
 

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)

Conditional formatting to represent a value when reached
 

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







"WLMPilot" wrote:

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)

Conditional formatting to represent a value when reached
 

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

Sorry,
Les

"PDC" wrote:

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







"WLMPilot" wrote:

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)