Conditional Formatting in Excel

I was working in Microsoft Excel and got a bit stuck on an issue with a formula, so I immediately went in search of the answer from my favorite Excel teaching resource, chandoo.org. I did find the answer, but while I was there, a very helpful article caught my eye so I thought I’d pass it along.

Conditional formatting in Excel is one of those foundational techniques that you must employ when creating business intelligence dashboards with excel. I’m talking about coloring certain cells a different color depending upon the value of that cell value.

For example:

Conditional Formatting Excel

Click here to read exactly how to accomplish this effect. It’s very important that you master it as you’ll use it over and over in your work.

Format cells with conditional formatting

And be sure to check out Chandoo’s School for Excel and his modules on Excel Dashboards.

If you are interested in using Excel for Dashboards, click on this banner to learn more about Excel School for Dashboards:

Excel School for Dashboards