Hello All,
Up to now I've not had much use for using the data validation function, but I am now using it to limit entries in a range of cells being allowed to take another cell's calculation below zero. The forumla applied to these cells is:
E17 contains the remaining hours available to be scheduled in a workshop. As hours are entered into the range of cells under the data validation they are subtracted from E17. This has worked to a point but I find myself in certain situations able to enter figures to take E17 below zero.
Due to the preconceived layout of the spreadsheet the range of cells that the data validation is applied to is not one single area, i.e. it is something like O17:22, S17:S22, W17:22, etc. My first suspicions are that this is where the problem springs from; the minus can be achieved by the first value entered into any of those column ranges, after which a second value added will correctly refuse the entry.
I have been careful to ensure I have selected all the right cells, have ticked “apply changes to all cells with these settings” when making changes and have tried both include and ignore blank cells.
Any ideas anyone?
Many thanks in advance for your help.
Simon.
Bookmarks