Excel Tip of the Month
Posted on October 27, 2009
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.
With the Dynamics NAV software we have gained efficiency and flexibility in all areas of financial management including accounts payable check processing, cash receipts application, and particularly general ledger applications as it applies to adding programs and companies; financial statement reporting; exporting information into excel for analysis; and importing general ledger entries. The implementation team from CES was very knowledgeable and thorough so that the transition was very smooth!
Mike Matthews
Seven Hills Foundation
Worcester, Massachusetts