+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting for Standard Deviations

  1. #1
    Registered User
    Join Date
    08-19-2014
    Location
    Colorado
    MS-Off Ver
    2010
    Posts
    1

    Conditional Formatting for Standard Deviations

    Need some help. I have a row of data that I would like to apply conditional formatting that formats values that are above or below 1, 2, 3 standard deviations. The rules I added are: change color to yellow for 1 std dev above average, change color to orange for 2 std dev above average, change color to red for 3 std dev above average. HOWEVER- when I apply the changes to the data everything that is 'between the average and 1 standard deviation' remains white. Would anyone know the formula I would need to enter to get this information to turn a different color (Green or Yellow)? Here is my data:
    158
    37
    48
    135
    102
    124
    85
    106
    185
    132
    91
    232
    Any help you could provide me would be greatly appreciated! Thanks!

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello ajzeleny,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/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. Conditional Formatting with standard deviations
    By joker007 in forum Excel General
    Replies: 12
    Last Post: 10-01-2009, 06:25 PM
  2. 4 Standard Deviations
    By NathanScott in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-03-2008, 04:52 AM
  3. [SOLVED] Calculate 2 Standard Deviations
    By Michael in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-17-2006, 01:15 PM
  4. Mean of standard deviations across columns?
    By ModelerGirl in forum Excel General
    Replies: 3
    Last Post: 02-04-2006, 01:00 PM
  5. Standard deviations in Excel
    By Fred Zack in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-14-2005, 09:05 PM

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