ChristineJ
Well-known Member
- Joined
- May 18, 2009
- Messages
- 761
- Office Version
- 365
- Platform
- Windows
I'd like to see if there are ways to return three different comments based on violations of "my rules" for amounts in range B1:C11.
Rule 1 - all numbers in column B must be entered before any numbers in column C are entered
Rule 2 - no rows should be blank if a number appears in either column in the following row
Rule 3 - only one number should appear in each row
If a rule is violated, a comment would appear in column E. Each rule's comment would appear in a different row. Thanks!
Rule 1 - all numbers in column B must be entered before any numbers in column C are entered
Rule 2 - no rows should be blank if a number appears in either column in the following row
Rule 3 - only one number should appear in each row
If a rule is violated, a comment would appear in column E. Each rule's comment would appear in a different row. Thanks!