#1
|
|||
|
|||
Allow Entry In Cell Based On Value In Another Cell
Kindly look at the table below.
Along A1, A2, A3,….., we have a list of fruits. Along B1, B2, B3,……, we have a list of the quantities of each item. Along C1, C2, C3,……, we have the corresponding calorific values of each fruit. Along the subsequent columns, we enter the number of a particular fruit eaten that day. How can I ensure that the total number of fruits entered does not exceed the total quantity available, i.e., since we have 3 oranges, all of which have been consumed by Tuesday, if I try to enter an orange on Wednesday it, either, prevents me from entering any value in that cell, or warns me. Also, how can I ensure that at the bottom, it automatically displays the sum of the calorific value of fruits consumed that day. |
#2
|
|||
|
|||
Maybe like the attached.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Increase number in cell, based on value in adjacent cell | scottyb | Excel | 3 | 02-02-2017 03:51 AM |
How to have one cell show a value based on the entry of another cell? | Marvinapplegate1964 | Excel | 1 | 05-04-2016 01:49 PM |
Need help with using traffic lights in one cell based on date value in a different cell | wmedjaxnjr | Excel | 1 | 04-09-2016 04:22 PM |
Trying to update a table cell with a value based on a drop down box entry | mkasem | Word VBA | 2 | 09-29-2013 08:36 PM |
Change formula cell range based on cell value | Scoth | Excel | 4 | 10-25-2012 07:51 AM |