|
» Applying Formatting Only to Cells Containing Text
CATEGORY: Excel Text |
VERSIONS: 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. |
| Screenshot // Applying Formatting Only to Cells Containing Text |
  |
|
RATING:
3.66
VIEWS: 29026 |
||||
Sponsors:
 |
Book Store:
Recommended Books:
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Business Plans Kit for Dummies (With CD-ROM)
- Windows XP for Dummies
- Guide to Financial Reporting and Analysis
- Microsoft Excel 2002 Simply Visual
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
Related MS EXCEL TIPS:
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.
