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
Applying Formatting Only to Cells Containing Text



Leave a Reply

Your email address will not be published. Required fields are marked *


9 × = thirty six

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>