A basic formula might look like this: =A2+B2. This basically tells Excel to add the number in cell A2 to the number in cell B2, and then show the result in the cell where you typed the formula.

With the use of Excel’s conditional formatting, you can set the rules once and let Excel do the highlighting for you.