If you apply a Conditional Number format to a cell, the formatting that you specified may not be applied to the entire cell contents when the
condition for that format is met in the cell.
↑ Back to the top
The formatting that you specified for a Conditional Number format may not be applied to the entire cell contents if the cell contains Rich Text formatting.
↑ Back to the top
If you want the formatting that you specified for a Conditional Number
format to be applied to the entire cell contents, remove any Rich Text
formatting in the cell.
↑ Back to the top
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
↑ Back to the top
The following steps demonstrate the issue described in the "Symptoms"
section earlier in this document:
- Open a new worksheet and enter the following in Sheet1:
- Double-click cell A1 to activate in-cell editing.
NOTE: If you have turned off the option to allow editing directly in cells, you will need to turn it back on for this demonstration. To turn on direct editing in cells, click Options on the Tools menu; click the Edit tab, and then click to select the Edit directly in cell check box. - Select just the "rich-text" portion of cell A1, and then click
Cells on the Format menu.
- In the Format Cells dialog box, click the Font tab. Then, click Bold in the Font style list, and click OK.
- Press ENTER. Note that the "rich text" portion of cell A1 is bold.
- Select cell A1, and then click Conditional Formatting on the Format menu.
- In the Conditional Formatting dialog box, set the first drop-down box to Cell Value Is; set the second drop-down box to equal to, and then type this is rich-text in the box to the right of the second drop-down box.
- Click Format. On the Font tab in the Format Cells dialog box, click a red color in the Color drop-down box, and then click OK.
This will set the conditional formatting for the cell so that when cell
A1 contains the text "this is rich-text" (without the quotation marks),
the text in the cell will change to red. - Click OK in the Conditional Formatting dialog box.
NOTE: Only the "this is" portion of cell A1 is changed to red.
↑ Back to the top
For more information about Conditional Formatting, click Microsoft Excel Help on the
Help menu, type conditional formatting in the Office Assistant or
the Answer Wizard, and then click Search to view the topics
returned.
↑ Back to the top