View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
dlw dlw is offline
external usenet poster
 
Posts: 510
Default Help to validate MULTIPLE numbers in one cell, not just the total

you have to put each individual number in a cell, do your check on those
cells, then sum them in another cell.

"amanske" wrote:

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