View Single Post
 
Old 06-10-2014, 08:12 AM
Carchee Carchee is offline Windows 7 64bit Office 2007
Advanced Beginner
 
Join Date: Dec 2013
Posts: 46
Carchee is on a distinguished road
Default Enter a number in a locked equation within a cell that then calculates

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.
Reply With Quote