| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| Inserting the same value until the same value is reached again | Excel Discussion (Misc queries) | |||
| Inserting the same value until the same value is reached again | Excel Discussion (Misc queries) | |||
| IF limit reached... what function would be better? | Excel Worksheet Functions | |||
| Add one until 171 is reached | Excel Worksheet Functions | |||
Threaded Mode
