software

To all,

I saw this feature on a spreadsheet before, but I was unable to figure
it out.

For example, the total assets must equal total liabilities and
shareholder's Equity. So I have in cell A2 the sum of all Asset
accounts from another tab, in call A3 the sum of all Liabilities
accounts from another tab and in call A4 the sum of all Equity accounts
from another tab, then, in cell A5, the result should equal zero if I
have no mistakes. quot;Assets minus sum of Liabilities and equity
(A2-SUM(A3,A4))quot;. If I have an error in the other tabs, the cell
returned a background color, which was RED. How do you do this without
VBA? The spreadsheet didn't have macros....

Thanks for your help--
JGarces
------------------------------------------------------------------------
JGarces's Profile: www.excelforum.com/member.php...oamp;userid=30406
View this thread: www.excelforum.com/showthread...hreadid=500744What you want to use is conditional formatting: Format gt; Conditional
Formatting.

Using your example, click in cell A5, then Format gt; Conditional Formatting.
Now set Condition 1 to quot;Formula isquot;, and in the formula box type (without the
quotes) quot;=A2-SUM(A3:A4)lt;gt;0quot;. Now click the Format button and select the
Patterns tab and then the color. Click OK twice

quot;JGarcesquot; wrote:

gt;
gt; To all,
gt;
gt; I saw this feature on a spreadsheet before, but I was unable to figure
gt; it out.
gt;
gt; For example, the total assets must equal total liabilities and
gt; shareholder's Equity. So I have in cell A2 the sum of all Asset
gt; accounts from another tab, in call A3 the sum of all Liabilities
gt; accounts from another tab and in call A4 the sum of all Equity accounts
gt; from another tab, then, in cell A5, the result should equal zero if I
gt; have no mistakes. quot;Assets minus sum of Liabilities and equity
gt; (A2-SUM(A3,A4))quot;. If I have an error in the other tabs, the cell
gt; returned a background color, which was RED. How do you do this without
gt; VBA? The spreadsheet didn't have macros....
gt;
gt; Thanks for your help
gt;
gt;
gt; --
gt; JGarces
gt; ------------------------------------------------------------------------
gt; JGarces's Profile: www.excelforum.com/member.php...oamp;userid=30406
gt; View this thread: www.excelforum.com/showthread...hreadid=500744
gt;
gt;

Check out...
Formatgt;Conditional Formatting...
HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.quot;JGarcesquot; wrote:

gt;
gt; To all,
gt;
gt; I saw this feature on a spreadsheet before, but I was unable to figure
gt; it out.
gt;
gt; For example, the total assets must equal total liabilities and
gt; shareholder's Equity. So I have in cell A2 the sum of all Asset
gt; accounts from another tab, in call A3 the sum of all Liabilities
gt; accounts from another tab and in call A4 the sum of all Equity accounts
gt; from another tab, then, in cell A5, the result should equal zero if I
gt; have no mistakes. quot;Assets minus sum of Liabilities and equity
gt; (A2-SUM(A3,A4))quot;. If I have an error in the other tabs, the cell
gt; returned a background color, which was RED. How do you do this without
gt; VBA? The spreadsheet didn't have macros....
gt;
gt; Thanks for your help
gt;
gt;
gt; --
gt; JGarces
gt; ------------------------------------------------------------------------
gt; JGarces's Profile: www.excelforum.com/member.php...oamp;userid=30406
gt; View this thread: www.excelforum.com/showthread...hreadid=500744
gt;
gt;