I have validated a cell by data validation.
Now, it can hold only values between 0 to 100. if user enters value out of range i.e. below 0 or above 100 a message box appears to inform that value must be between 0 to 100.
I have also validated another cell with same range of values as above but it depends on other cells(i.e. it containing formula) but if the result is out of range i.e. below 0 or above 100 message box does not appear.
I want to display a message box to inform user check your values. How can I do this?