Hi, In my sheet there is some stock values.(e.g) Column C, E & G. In"C"column there is
minimum Values, if below the minimum Value the "Pop Up Message" will come as' LOW VALUE".The same way"E"column if value is more than instructed value, the message will PopUp "High Value" & finally"G"column i have to put Three condition, If Value meet the first condition "LOW ", if meet the second condition,"BORDER" & if meet the final condition "OUT OF RANGE". I have add simple Macro in Column "C" only for reference.
The macro should work in C1 to C100,E1 to E100 & G1 to G100.
Thanks for advance
Bookmarks