Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i put a limit on an entry in a cell?
Hi, I am trying to organise a timesheet and there is one thing that I can't
get past. How do I put a limit on a number entered into a cell? My example is, I want the "hours carried forward" cell to stop at 20. I would like this to just apply to one cell but on all worksheets. For instance, if I have 21 hours flexi accumulated in week one and I want the flexi carried over to week two (separate worksheet), instead of it showing 21 I would like it to remain at 20. However, I still want the cells to allow numbers lower than 20. Can anyone help me out please? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Entry That Locks Selected Cells From Any Data Entry. | Excel Worksheet Functions | |||
Can I limit a cell to 2 characters? | Excel Discussion (Misc queries) | |||
Height of Cell limit | Charts and Charting in Excel | |||
limit text entry in a range of cells | Excel Discussion (Misc queries) | |||
Nested IF limit or Open parentheses limit | Excel Discussion (Misc queries) |