» Applying Formatting Only to Cells Containing Text
CATEGORY - Excel Text
VERSION - All Microsoft Excel Versions
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.

Book Store:
Recommended Books:
- Harry Potter and the Order of the Phoenix (Book 5)
- Business Analysis with Microsoft Excel (2nd Edition)
- Real Estate Loopholes: Secrets of Successful Real Estate Investing
- How to Pay Zero Taxes (Annual)
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
No comments have been submitted.

