Tuesday, January 3, 2012

Microsoft Excel Tutorial: How to use Conditional Formatting


Hello! I'm Back with a tutorial! If you noticed, I didn't have any post last December 2010. I had a lot of things to do, well, because of the Holidays. Before I forget, let me greet you a very happy new year! My first post for this year is a tutorial on how to use conditional formatting in EXCEL

What is Conditional Formatting?

Let us check what Microsoft has to say about this feature. In Excel Help, they said:

Use a conditional format to help you visually explore and analyze data, detect critical issues, and identify patterns and trends.

If I, personally, would read that definition, I still will have a hard time figuring out what it does exactly. Basically, Conditional Formatting is about visual identification. Let me give you a scenario:

If you have a sales business, let's say, Perfumes. And you would like to know, in one look, which perfume sells more. I have a simple example about what this "in one look" is about, Graphically:
Excel, Excel How to, Excel Tutorial, How to use Conditional Formatting in Excel, in Excel, In Microsoft excel, Microsoft Excel, Microsoft excel tutorial

As you can see, the above graph would explain how Conditional Formatting in Excel can help you check your products in just one look. Let me teach you how to do it in 10 Simple Steps: