Hi I am trying to put 2 formulas together in one cell

The first is to give a sum, i.e. : =(D3+F3+H3+J3)-(C3+E3+G3+I3)

The second is to check the resulting number above against a number total in 2 other cells with similar sum formulas and then alert or change colour of cell if any of the three are not the same number.

Can anyone assit?

Thank you


(Note: Instructions and screenshot from Excel 2013 but should apply to Excel 2010)

Let's assume the cell with your formula is C4 and the "two other cells" are C5 and C6.

  1. Enter your formula in cell C4
  2. With cell C4 selected, go to Conditional Formatting -> New rule...
    • Select Use a formula to determine which cells to format
    • Enter the formula as shown below
    • Press the Format... button and select the highlighting you want(eg white text on red background)
    • Press the OK button to apply the conditional format.

Screenshot of Excel 2013

  • Cute trick, comparing the MIN to the MAX. I'll have to try to remember that. – Scott Jul 1 '14 at 0:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.