validations for negative values

rajraj9876 · Oct 27th 2013

Hi Experts,
I have to write a VBA code to validate for all active cell with negative values. In case of a negative value entered, a message box thrown " No negative values allowed" and the that particular cell should become red color. Again on refresh the red color validadation should disappear.
Thanks
Raj

Faysalalam2008 · Oct 28th 2013

Re: validations for negative values

Select Cell or Whole column,
Go to data Validation select Custom and type this
=$I1>=0
Click Ok

validations for negative values

Participate now!

Share