Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-07-2017, 10:06 AM
koltanga koltanga is offline Allow Entry In Cell Based On Value In Another Cell Windows 10 Allow Entry In Cell Based On Value In Another Cell Office 2007
Novice
Allow Entry In Cell Based On Value In Another Cell
 
Join Date: May 2017
Posts: 4
koltanga is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 05-07-2017, 10:26 AM
xor xor is offline Allow Entry In Cell Based On Value In Another Cell Windows 10 Allow Entry In Cell Based On Value In Another Cell Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,035
xor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of light
Default

Maybe like the attached.
Attached Files
File Type: xlsx Fruit.xlsx (70.2 KB, 3 views)
Reply With Quote
Reply

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
Allow Entry In Cell Based On Value In Another Cell How to have one cell show a value based on the entry of another cell? Marvinapplegate1964 Excel 1 05-04-2016 01:49 PM
Allow Entry In Cell Based On Value In Another Cell 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
Allow Entry In Cell Based On Value In Another Cell 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


All times are GMT -7. The time now is 11:34 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft