Excel Tip of the Month

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.