Mike Kelly's Blog

From my Office to Yours

Browse by Tags

Tagged Content List
  • Blog Post: 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 up...
  • Blog Post: 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 - i.e. if the value is TRUE...
Page 1 of 1 (2 items)