Excel Magic Trick 861: Conditional Format 50 Columns w Format Painter +/- 1 Standard Deviation

Download from: http://people.highline.edu/mgirvin/ExcelIsFun.htm
1. Conditional Format 50 Columns Using Format Painter to apply Format to Above Below Standard Deviation
2. See AVERAGE and STDEV and AND functions and Mixed Cell References to create Logical Formula that can be used in the Conditional Format Dialog Box
3. See a trick for Standard Deviation Conditional Formatting that will allow us only two formulas instead of three

Category:

Education

Tags:

• Excel
• 2003
• 2010
• 2007
• Mike
• Girvin
• excelisfun
• Highline
• Community
• College
• Conditional
• Format
• 50
• Columns
• Using
• Painter
• to
• apply
• Above
• Below
• Standard
• Deviation
• See
• AVERAGE
• and
• STDEV
• AND
• functions
• Mixed
• Cell
• References
• create
• Logical
• Formula
• that
• can
• be
• used
• in
• the
• Dialog
• Box

[SweetwaterGrowers]

Mike do you have a class that I can take?

[ExcelIsFun]

@SweetwaterGrowers , where do you live?

If you live in the Seattle area, okay, otherwise, all my classes are for free here at YouTube. 100% of the classes.

[MrDerekw24]

@ExcelIsFun Continued; I have found they can turn off auto calculation and uncheck "don't calculate during save" but that defeats what they are trying to do. I was hoping I could send you a sample or something. I have weeks invested including beefing up hardware and OS to 64-Bit. It helps but still takes 8 minutes to calculate and pegs the CPU at 100% rendering the PC's useless. I am thinking they are just doing something wrong but I can't find someone to determine that.

Thank you,

[ExcelIsFun]

@MrDerekw24 , I do not do consulting This alternative web site does consulting for a fee or you can post Q for free at Message Board:

mrexcel [dot] com/forum

[SweetwaterGrowers]

@ExcelIsFun No I live in Georgia. I am trying to do an excel sheet for more complex Inventory. Ex. If I make a widget then it takes X of this item and Y of another Item. Maybe you can help me on this

[ExcelIsFun]

@SweetwaterGrowers , sorry, I do not do consulting.

[carpyjedi1985]

@ExcelIsFun looks like you made the last conditional formatting ">=" as opposed to just ">" when you copied in the formula from the clipboard :) its about 7:50mins in! Other than that good stuff as always!

[MrDerekw24]

@ExcelIsFun , Hello your videos are awesome. I just found them and can't take get away from the computer. I have an issue at work with a workbook that takes 15 minutes (calculating) to do just about anything, saving, filter, etc. They are around 500,000 rows and are using basic Vlookups. We (IT) aren't excel experts and I am looking for someone to be able to say "you have totally hit the boundaries" or "the formatting is wrong". I was wondering if I could engage you off-line? Derek

[ExcelIsFun]

@knrd87 , great tip!

[ExcelIsFun]

@krn14242 , you are welcome!