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
