| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validate a total of a row
I have this, simplified, spreadsheet:
Name A, Name B, Name C, etc in columns B1 to M1 In row 2 to row 11 are Work Functions. The staff have to enter a time against each function but the total for each row can not exceed 15 minutes. Can someone help with the formula? Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Validate a total of a row
1. use conditional formating to give you a red flag when the total is not 15
min. 2. Or use VBA to achieve the goal "Charles" wrote: I have this, simplified, spreadsheet: Name A, Name B, Name C, etc in columns B1 to M1 In row 2 to row 11 are Work Functions. The staff have to enter a time against each function but the total for each row can not exceed 15 minutes. Can someone help with the formula? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| validate | Excel Discussion (Misc queries) | |||
| Looking up a name and then being able to validate it | Excel Worksheet Functions | |||
| Looking up a name and then being able to validate it | Excel Worksheet Functions | |||
| How to validate | Excel Worksheet Functions | |||
| Validate drop down box | Excel Worksheet Functions | |||
Hybrid Mode
