+ Reply to Thread
Results 1 to 2 of 2

VBA-Highlight standard deviation in excel

  1. #1
    Registered User
    Join Date
    07-14-2023
    Location
    MUMBAI
    MS-Off Ver
    13
    Posts
    2

    VBA-Highlight standard deviation in excel

    I Need A VBA code to highlight a cells within table range automatically if it crosses standard deviation Please help Thanks

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: VBA-Highlight standard deviation in excel

    Welcome to the Forum Ajay_2510!

    There is no way to answer this without knowing what your table looks like, what data you want to highlight, and how to determine the standard deviation. Please see "HOW TO ATTACH YOUR SAMPLE WORKBOOK" in the yellow banner at the top of the page and attach your file. When you provide the file show at least one example of the result you want.

    Also a single value cannot cross a standard deviation. Do you mean if a value is more than one standard deviation away from the mean?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel Standard Deviation and other problem
    By joshi91 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-07-2013, 01:18 AM
  2. Excel - Standard Deviation Example?
    By elmarko123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-26-2010, 09:53 AM
  3. Standard deviation calculations with excel
    By kimily in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-18-2007, 07:19 AM
  4. How do I insert standard deviation to my graphs in excel?
    By sanfrancisco_cat in forum Excel General
    Replies: 0
    Last Post: 03-21-2006, 03:10 PM
  5. [SOLVED] Relative standard deviation in Excel
    By Dennis Falkenstrøm in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-06-2005, 08:00 AM
  6. Re: Relative standard deviation in Excel
    By Barb Reinhardt in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-06-2005, 08:00 AM
  7. Is there a standard deviation calculation in Excel?
    By panducci in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-23-2005, 02:06 PM
  8. how do I plot mean and standard deviation in excel
    By amg in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-06-2005, 12:06 AM

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