I am new to Data Validation and I could not find the correct formula that I want to use.
I want to restrict data entry on cell J4 by checking all the values from cell i6 to i20, and only allow entering data on J4 if it is greater than every values from i6 to i20.
Please see my sample workbook. I think I have made some mistakes on formula that I had entered on Data Validation Rule (at cell j4)
Bookmarks