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