+ Reply to Thread
Results 1 to 2 of 2

Macro for whole column with a condition

  1. #1
    Registered User
    Join Date
    05-08-2010
    Location
    Qatar
    MS-Off Ver
    Excel 2003
    Posts
    24

    Smile Macro for whole column with a condition

    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
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    05-08-2010
    Location
    Qatar
    MS-Off Ver
    Excel 2003
    Posts
    24

    Re: Macro for whole column with a condition

    Hi, Take Your Won Time.
    I have attached one excel file name "RECORD" & one word file "FORMULA".
    Please check the formula file i explained clearly.

    Thanks,
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1