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.
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.