I’d like to outright prohibit the entry of non-numerical characters into cells (except the . for the decimal).
A conditional format that changes that cell with a non numerical character, to red, would suffice. I tried but was unable to find a conditional format argument that would do this.