Excel entry must be negative integer
Posted on 2012-03-11
I have 5 cells in my worksheet that must be keyed as a negative interger with 2 decimals points.
Range (G6, G9, G10, G11, G20) all must be keyed as negative or a message box appears stating that entry must be entered as negative number.
Can you assist me in setting my worksheet change to monitor these cells and msg box anything that is not in compliance.