I am having a problem with cell validation, but only when a user enters correct data and then clicks off onto another cell.
For Example in B1 I have the formula =A1+5. In cell A1 I put the following validation =B1>5. This ensures that the value just typed into A1 is a number and that it is greater than 0. When a user enters "1" into A1 and then clicks onto another cell, the validation error comes up, even though 1 is an acceptable value. If the user enters 1 and then presses enter, or tab, or arrow over, then the validation works as expected.
I realize I could add instructions not to just click off a cell, but that will confuse people and I am trying to make this easy to use for people who rarely use Excel. Is there a way around this problem?
Bookmarks