Excel data validation using Excel js

0
votes

I need help with cell validation. I have the min and max value. I have already stopped users to enter special characters in a cell. However, in testing I found that users can enter % in a cell and excel is not prompting the user for the invalid character.

I am using Excel.js which creates templates. In data validation, I have selected custom and my formula is =AND(M4>=0,M4<=100).

How can I create this formula? Only a number should be allowed, rest all result in an error.

enter image description here

enter image description here

1
excelexcel-formulaexcel-2010exceljs
Please read Under what circumstances may I add “urgent” or other similar phrases to my question, in order to obtain faster answers? - the summary is that this is not an ideal way to address volunteers, and is probably counterproductive to obtaining answers. Please refrain from adding this to your questions. - halfer

1 Answers

0
votes

In case anyone else needs it.

formulae: ['=AND(A5>=0,A5<=100,CELL("format", A5)<>"P0")']