Learn how to highlight cells with negative values in Excel. Make negative numbers stand out in Red using Conditional or Custom Formatting.

You can subtract numbers in Microsoft Excel in a few different ways, depending on your data and formatting.

If, for example, you wanted to calculate your returns after taxes, you could input the amount of taxes due in the table as a negative number to recalculate an after-tax return.

Variance is a measurement of the spread between numbers in a data set. The variance measures how far each number in the set is from the mean. You can use Microsoft Excel to calculate the variance ...

A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel PivotTable do all the work.

The article How to Calculate the Regression of 2 Stocks Using Excel originally appeared on Fool.com. Try any of our Foolish newsletter services free for 30 days .