Excel Tutorial: Conditional Formatting in a Balance Sheet

In this video I demonstrate two ways to use conditional formatting in Microsoft Excel that can be useful to analyzing a balance sheet: 1) visually identifying when assets are in balance with liabilities and shareholders' equity; and 2) coloring scaling an analysis such as the debt-to-asset ratio within a pre-defined range of acceptability.