» Applying Formatting Only to Cells Containing Text

To apply formatting only to cells containing text, use the Conditional Formatting technique:

1. Select a range of cells containing text.
2. From the Format menu, select Conditional Formatting.
3. In Condition 1, select Formula Is from the dropdown list.
4. In the Formula Box, enter the formula:
=ISTEXT(A1)
5. Click Format.
6. Select the desired format from the Format Cells dialog box, and then click OK.
7. Click OK to close the Conditional Formatting dialog box.
Screenshot // Applying Formatting Only to Cells Containing Text