I understand. I will also add that there is a macro button that adds 0 to all entry cells. It simply adds 0 from right to left to reset the cells. This is why there is never a blank cell in the sheet. This is why I was wondering about switching section I6>=L6 to:
L6=0 other possibility
L6<>0
to satisfy the condition of 0 always being there unless a user is able to enter a value into L6 in which case once a value is there I6 can no longer have data be input into it? Would either of those 2 solutions work better or am I way off base? I am going to try both myself after I post here. I am just going to change that section. I will post the results and if it works ask anyone to please cut out anything that is not necessary.
my L6=0 worked as I needed!
So the formula for that cell is:
=OR(AND(L6="",F6<>"",F9<>"",F12<>"",SUM(F6,F9,F12),I6<16,MOD(I6,1)=0),AND(L6=0,F6<>"",F9<>"",F12<>"",SUM(F6,F9,F12),I6<16,MOD(I6,1)=0))
This is rather cumbersome but I will do it for all cells if need be, but I was wondering if there were any extraneous bits of information in formula that could be trimmed out? Let me know according to conditions listed below which section or sections can be trimmed, why and what the removed section does if you can.
Full conditions I need:
1. All cells need to be whole positive numbers (integers?) entered
2. No blank input cells as all will have at least 0 in cell but to check all related cells anyway to make sure it is not blank
3. All cells will have a ceiling value it must be under for data input to stay
4. Like I6 most cells have a floor value a previous cell(s) must exceed for data input to stay
5. Like I6 most cells have a cell(s) further up the chain that will check to see if the value is default of 0 for data input to stay
6. Macro Button created to enter a value of 0 from the furthest right cells going to the left still works. (Reset button)
Also protecting the worksheet while unchecking the protect cell does this protect the data validation and allow the cell to be used or is there a different way to go about this?
Now using what I learned from that I am trying to create this. I tried a few things but reverted to this again because it works mostly how I want it. What I mean to use as an example: if L6 has a value of at least 1 I don't want someone going back to I6 and changing to a lesser value than the condition value to allow enteries into L6. Is it possible to do this?
