Prevent number increase; allow number decrease

[faeryluv]

Is it possible to lock a cell down to where the numbers entered can't be increased, only decreased? When sending out our spreadsheets for employees to adjust orders, for example, sometimes we can't allow them to increase the amount. We want to allow them to decrease, but not increase. Half of them ignore our instructions, increase the numbers, and make us have to go through dozens of lines to move the amounts back which takes a long time. Just thought I'd check with all of you geniuses out there with the hopes of making my life a lot easier! Lol! Thanks in advance <3

 

[hrayani]

Hi,

You can use data validation.
Go to data validation > Select whole number from Allow list
And there you can set the Min and MAX limit

Regards,

Humayun

 

[faeryluv]

Hi,

You can use data validation.
Go to data validation > Select whole number from Allow list
And there you can set the Min and MAX limit

Regards,

Humayun

This is fantastic, thank you! I don't suppose there's a way to do this without having to add a second column? I'd hate to have to enter the original amount into each cell validation, that is why I have added a separate column. See attached screenshot.

 

[hrayani]

So does that sort out the problem ??

 

[faeryluv]

So does that sort out the problem ??

By adding an additional column, yes. However, it would be nice to not have to do that. There's always hundreds of different item amounts so I can't type in a Maximum amount for each cell. Therefore, I have added an extra column (Original Amount) to set Maximum amount as "=A3". Do you think this is my best option for this, or is there a better way?

 

[hrayani]

Do you think this is my best option for this, or is there a better way?

Sorry.. I don't think of any better option
Experts out here may come up with a better solution

Regards,

Humayun

 

[Fluff]

You can put a formula into the cells, to pull the original value across & use the data validation to prevent the value from being increased.

+Fluff v2.xlsm
	C	D
2	189	189
3	134	134
4	131	131
5	70	70
6	189	189
7	69	69
8	178	178
9	56	56
10	57	57
11	114	114
Main

Cell Formulas
Range	Formula
D2:D11	D2	=C2

Cells with Data Validation
Cell	Allow	Criteria
D2:D11	Whole number	<=C2

But there is nothing to stop a user from changing the original value in col C

 

[faeryluv]

Sorry.. I don't think of any better option
Experts out here may come up with a better solution

Regards,

Humayun

Thank you so much!

 

[faeryluv]

You can put a formula into the cells, to pull the original value across & use the data validation to prevent the value from being increased.

But there is nothing to stop a user from changing the original value in col C

Thank you! Humayun's solution works great; I was just trying to keep from having to add an additional column as the spreadsheet already contains many columns. However, adding the extra column is much better than nothing. I appreciate your assistance.

 

[hrayani]

you are welcome & thanks for the feedback