Shading a Cell Until Something is Entered

When creating a worksheet in which information must be entered into specific cells, you may find it helpful to shade the cells if they are blank, but have the shading removed if something is entered into the cell. You can easily accomplish this task by using the conditional formatting feature in Excel. Follow these steps:

1. Select the cell or cells that you want shaded if they are empty.
2. Choose Conditional Formatting from the Format menu. Excel displays the Conditional Formatting dialog box. (Click here to see a related figure.)
3. Use the Condition drop-down to choose Formula Is.
4. In the formula area, to the right of the drop-down list used in step 3, enter the following formula, replacing A1 with the address of the active cell selected in step 1.:

     =ISBLANK(A1)

5. Click Format to display the Format Cells dialog box.
6. Click the Patterns tab. (Click here to see a related figure.)
7. Select the color you want used for shading the cell if it is blank.
8. Click OK to dismiss the Format Cells dialog box. The shading color you selected in step 7 should now appear in the preview area for the condition.
9. Click OK.

All the empty cells among those selected in step 1 should now appear shaded. When you enter something into one of the shaded cells, the shading should disappear.