I want a certain limit on the total of my input data:
Is there a way to show a certain error message once the input results in a percentage of more than 100%?
Go to Solution.
Check the All products % total>1 or not..
Just extending the above, if you used a "1" instead of TRUE, you could use conditional formatting to highlight the products
Further information can be found here:
Hope this helps