Help to validate MULTIPLE numbers in one cell, not just the total

  • Thread starter Thread starter amanske
  • Start date Start date
A

amanske

I enter multiple numbers into one cell and they all have to be negative
numbers. I would like an error message to occur when a positive number is
added. I tried to validate it, but it only gave an error when the total
amount was positive.
EX:
Cell A1 shows-->-125 (=-130+5)
I want an error message when the +5 was entered
 
you have to put each individual number in a cell, do your check on those
cells, then sum them in another cell.
 
Back
Top