Using Excel is a great way to perform what-if analysis, and formulas generating random values that make sense for your forecasting help present a variety of outcomes for analysis.

The formula tells Excel to compute percentage markup and place it in the Percent Markup column. Copy the formula by clicking the black square in the lower right corner of cell C2 dragging down.

Counting records or values in Microsoft Excel is easy. Counting individual cells by their fill color definitely isn't. Using an old function and a matrix tames the problem.