Does anyone know if you can add an equation to a cell and somehow lock it, then be able to enter a number within the same cell where the equation where it is then calculated? To explain the process a bit further.... you would enter a formula in a cell and lock it, then within the same cell you could enter any number and the result would vary depending on what number you entered. I hope that makes sense. It's kind of like conditional formatting, it would be nice if Microsoft would add this to their conditional formatting.

I would like to do this without vba.