32 articles Excel 2010 Page 3 / 4

Conditional Formatting for Multiple Cells – Quick Memory Aid

This article is not for beginners, but serves as a memory aid for conditional formatting driven by formulas. For the basic stuff, go to http://www.contextures.com/xlcondFormat01.html For some examples of using conditional formatting, go to Excel: Alternate Row Colors / Color Banding, Column Colors and Checker Patterns In the conditional format, the formula will work as long as it returns…

What is the formula for weighted average (mean) in Excel?

=sumproduct([values],[weights])/sum([weights]) A weighted average (mean) is similar to the arithmetic average (mean), except values to be average are given different weight or emphasis. As seen in the example below, the weighted average is much lower than the arithmetic average, because there the value 0 carries a very strong weight (50). The formula bar also shows how cells should be…