Hi Folks,
I need multiple data validations on many cells on an excel worksheet;
1. We should only be able to input numbers greater than 0 in cells F6 and F7 and if something else we will input, should get an error.
2. We should not be able to enter anything if cell F5 = "No", we can only enter numbers when F5 = "Yes".
3. If we select F5 = "Yes", and then enter numbers in F6 and F7 and then select F5 = "No", it should erase the values from F6 and F7.
Hope I am clear with the need. The sample is attached for better understanding.
Thanks in advance...
Abhi
Bookmarks