i receive worksheets from customers with poorly formulas inputs that has many mistakes.
i need help with a macro that compares formulas inputs (not result) and if different found then colors it in red.
in Column A i have formulas and in Column B i also have formulas
lets say cell A2 has a formula =SUM(Sheet1!E1:F14) and cell B2 has =SUM(Sheet2!E1:F14)/SUM(Sheet2!D1:D14)
i need the macro to put in C2 1/SUM(Sheet2!D1:D14) becuase that is the difference between these two formulas. i do not know if obtaining such result is event possible in Excel?