J
JGarces
To all,
I saw this feature on a spreadsheet before, but I was unable to figur
it out.
For example, the total assets must equal total liabilities an
shareholder's Equity. So I have in cell A2 the sum of all Asse
accounts from another tab, in call A3 the sum of all Liabilitie
accounts from another tab and in call A4 the sum of all Equity account
from another tab, then, in cell A5, the result should equal zero if
have no mistakes. "Assets minus sum of Liabilities and equit
(A2-SUM(A3,A4))". If I have an error in the other tabs, the cel
returned a background color, which was RED. How do you do this withou
VBA? The spreadsheet didn't have macros....
Thanks for your hel
I saw this feature on a spreadsheet before, but I was unable to figur
it out.
For example, the total assets must equal total liabilities an
shareholder's Equity. So I have in cell A2 the sum of all Asse
accounts from another tab, in call A3 the sum of all Liabilitie
accounts from another tab and in call A4 the sum of all Equity account
from another tab, then, in cell A5, the result should equal zero if
have no mistakes. "Assets minus sum of Liabilities and equit
(A2-SUM(A3,A4))". If I have an error in the other tabs, the cel
returned a background color, which was RED. How do you do this withou
VBA? The spreadsheet didn't have macros....
Thanks for your hel