message box on cell content

C

Cooie

Hi
I'm fairly new to this but grateful for any help. I need a warning or
message box to pop up and stop invalid data being entered.
If the user enters a value in a range (C31:U41) that causes a negative value
in another range (C45:C55), then this is invalid data and they need to try
again with correct data.
Hopefully there's a simple answer to this.
 
P

Peter T

With C31 selected -

Data / Validation / Custom / Formula : =C45>=0

Also see Input msg & Error alert tabs

Copy (or drag) C31 down to C41

Regards,
Peter T
 
C

Cooie

Thank you so much, it worked a treat.
Cooie

Peter T said:
With C31 selected -

Data / Validation / Custom / Formula : =C45>=0

Also see Input msg & Error alert tabs

Copy (or drag) C31 down to C41

Regards,
Peter T
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Content of Cell clicked in another cell 2
Better error message when a user enters a value in a form comboboxthat is not valid 1
Replace microsoft forms message box with something more meaningful 4
Macro activated when a value in a cell changes 3
Multiple condition message box 1
Email Excel Cell Range using Macro 2
If loop based on logic function 0
type mismatch error in macro in excel 0

Top