Conditional formatting allows you to set specific formatting based on the contents of a cell. This formatting will apply as you add data to your spreadsheet. For example, if you are using an Excel spreadsheet to record expenditures, you can have categories of expenses appear in different font colors automatically. Select Conditional Formatting from the Format menu to open the dialog box. To apply conditional formatting, as in the example above, select Cell Value Is in the first dropdown box. Select Equal To from the second field’s drop-down menu and then type an expenditure category in the third box (Groceries, for example). You have now set up a condition such that any cell in which you type the word Groceries will be distinctly formatted. To set the distinct format for each condition, click the Format button in the dialog box. This will open an abbreviated version of the Format Cells dialog box available on the Format menu. In this dialog box, you can select formatting on the Font, Border, and Patterns tabs. When you have made your formatting choices, click OK to apply them to your selected Condition. For our example, go to the Font tab and select the red colored box from the Color drop-down menu. Then click OK. Now, when you type the word Groceries in any cell, it will appear in red when you press ENTER. To add another condition, click the Add button and repeat the process of creating a condition. For example, you could add a condition so that any cell in which you type Insurance will turn blue, or any cell containing Entertainment will turn yellow. You can define up to three conditions. To delete a condition, click the Delete button and Making formatting changes based on the content of a cell is made easy with Conditional Formatting.
Sign by Danasoft - Get Your Free Sign
