It's probably common but this is actually how I do testing in the one "production" spreadsheet that I have (for personal finance stuff).

+ conditional formatting that turns the cell background read if the value isn't "ok" twitter.com/tophtucker/sta…