Excel Conditional Formatting Against a Goal Value

Today, for a metrics worksheet I’m doing, I had a conditional formatting problem with Excel.  I suspect this is a pretty common problem.  I had a column of numbers showing the monthly results for a set of metrics (the rows) for this fiscal year, and I had an annual goal for each metric.  I summed…

1

Showing a Checkmark in Excel

I had a problem that was surprisingly not easy to do in Excel, and since it seems like a pretty common thing, I thought I’d provide a note here on how to do this. Problem: With Excel 2007, you want to display a “checkmark” or a “red x” in a column that has a logical value…

6