I typically set up a conditional format for checks like that.
Starting w/your 2nd entry, select Format, Conditional Formatting from the menu bar and enter:
Formula Is =ABS(A2-A1)<>1
Format Pattern Red (for example)
Copy format down as necessary.
...oops, didn't see other similar post
This message was edited by Scott R on 2002-09-25 09:57