Forum Discussion
Excel - Data Validation
Thanks - I had already tried that, but does not work. When the cell that is being calculated exceeds the value of cell C10, it is still populated. I want it to generate my error message in the event that the result is not Less Than value contained in (Max) cell C10. Further ideas?
Hello Steve-SDC,
Try to recalculate the cell with data validation after you set the data validation. If you set the data validation after you already calculated the cell, then it will not show an error.
- Thanks - tried that. Still did not work. I want the User to manually enter J22 and K24. The Result is calculated to K25. But I want an error message (or dis-allow K25 to be populated) IF K25 is > C10.
Let assume we have correct result at the beginning
Now we are truing to enter 55 into K24
With this we have two options - enter correct value to K24 or cancel and return back to initial data.
Or I misunderstood and you consider another scenario?
Yes, the example you have shown matches mine, but I am not getting the error flagged properly SergeiBaklan