| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how to get a warning when data is entered wrongly
i have a spreadsheet. The ENTRY and EXIT should tally.
ENTRY----total of col A:D is in E3. EXIT---- total of col G:J is in K3. i expect to get E3=k3 cell K3 is formatted as the sum of G:J when i enter a data wrongly in anywhere between the cells G:J a warning should come in col K3 (of course after entering data in all the four cells G:J).the idea is the number in entry should tally with that of the exit. is it possible? the excel file is attached. Last edited by sumesh56 : October 18th 12 at 05:39 PM |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting for wrongly entered 9 digit numbers | Excel Programming | |||
| Using a Macro in Excel 2004 to move entered data from one sheet toanother and space between rows when next data is entered? | Excel Programming | |||
| List Box - Option If wrongly selected | Excel Programming | |||
| Time displaying wrongly | Excel Discussion (Misc queries) | |||
| sorry i put wrongly for padded leading 0 | Excel Programming | |||
Threaded Mode
