Conditional Formatting and Custom Format – Use More than Three Colors

Conditional formatting (in pre Excel 2007 versions) had a limitation of only allowing for upto three conditions for formatting cells. A quick way to include more than three conditions when using conditional formatting is to use the custom format feature in tandem with it. Conditional formatting can be used to specify the first three conditions and then upto three additional conditions can be specified using custom format - giving us 6 different colors to ...

Continue Reading

Conditional Formatting and Custom Format  - Use More than Three Colors

Conditional Formatting In Excel

Posted on 22 March 2009

Conditional Formatting In Excel
Conditional Formatting is one of the most useful features of Microsoft Excel. And while most people are happy to use it for changing the color of the text in a particular cell, there are endless ways in which it can be extended. Here are a few: Hide errors Remember when you had a copy a complicated formula onto 40,000 cells and some of them gave you the dreaded #DIV! error. That did really ...
Continue Reading

Comments     

Cricketing Heat Map

Posted on 22 February 2009

Cricketing Heat Map
Heat maps are pretty versatile. They have been used for everything ranging from charting home prices to changes in the stock market. (Average Listing Price for US states, week ending Feb 17, 2010. Source : www.trulia.com) (SNP performance, Feb 19, 2010. Source : www.finviz.com/map.ashx) Inspired by the last ball win over the South Africans yesterday night, I wondered if some of that action could be captured in a graph. ...
Continue Reading

Comments (5)

Excel Dashboard : Data Organization

Posted on 23 August 2008

Excel Dashboard : Data Organization
Having our first view of the data More often that not, dashboards get prepared with a large amount of data. Even if that’s not the case, it always makes send to have your data nicely laid out. That way, whenever you have to go back and check the accuracy of the data, it becomes so much easier. Let’s work with an example. Suppose we've just been provided with one year’s worth of sales and target numbers for the regional and ...
Continue Reading

Comments     



Translate

Chinese (Simplified)DutchEnglishFilipinoFrenchGermanHebrewHindiItalianJapanesePortugueseRussianSpanish

treeemap software for excel