Excel: How To Create a Conditional Format

Home -> Windows -> Office -> Excel

From the computer of: shamanstears (738 recipes)
Created: Oct 24, 2006     Updated: Oct 26, 2006

Add to:

In Excel, you can change your data's appearance based on its value. For example, you could change the color of negative balances in your worksheet to be red while positive numbers are black. To do this, follow the steps in this Tech-Recipe.

1. Select the cell to be formatted.

2. Click Format and then select Conditional Formatting.

3. In the second dropdown, select the operator to use in the test.

4. Type the arguments to use in the condition.

5. Click the Format button to bring up the Format Cells dialog box.

6. Use the controls to create the format for the condition.

7. Click OK.