I'm using MS Excel 2007. I would like to restrict the data entry of some cells in a worksheet to certain numeric values and also forbid the entry of formulas in those cells.
As an example, given this data
| A | B | C ---+----+----+----- 1 | 4 | 26 | 2 | | |
I would like to only allow literal numeric values greater than 100 to be entered in
I tried using
100] but this also allows certain formulas to be inputted. If you try entering
=A1*B1 in cell
C1, because it evaluates to more than 100, the data validation allows the formula.
How do I enforce this extra no-formula restriction?