| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
how do work with validetion
I know that its possable to do with validation that I should not be able to enter in column f:f that the total should be more then 100 -- shlomo ------------------------------------------------------------------------ shlomo's Profile: http://www.excelforum.com/member.php...o&userid=15304 View this thread: http://www.excelforum.com/showthread...hreadid=320615 |
|
#2
|
|||
|
|||
|
Shlomo,
In the Validation dialog, choose "Custom" from the Allow list, and use the formula =SUM(F:F)<=100 -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "shlomo" wrote in message ... I know that its possable to do with validation that I should not be able to enter in column f:f that the total should be more then 100 -- shlomo ------------------------------------------------------------------------ shlomo's Profile: http://www.excelforum.com/member.php...o&userid=15304 View this thread: http://www.excelforum.com/showthread...hreadid=320615 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Service work order | Charts and Charting in Excel | |||
| I need a template for a work schedule. | Charts and Charting in Excel | |||
| How do I make 'save as web page' with interactivity work properly. | Charts and Charting in Excel | |||
| Do you have a work in progress sheet | Charts and Charting in Excel | |||
| Why doesn't this work? | Charts and Charting in Excel | |||
Hybrid Mode
