» Applying Formatting Only to Cells Containing Text
CATEGORY - Excel Text
VERSION - All Microsoft Excel Versions
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.
Book Store:
Recommended Books:
- Special Edition Using Microsoft Outlook 2002
- Yes, You Can Time the Market!
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- PowerPoint® 2002 For Dummies®
- Fish! A Remarkable Way to Boost Morale and Improve Results
- Microsoft Outlook 2002 for Dummies
No comments have been submitted.
