XL97: Conditional Formats May Not Work on Rich Text Cells

Last reviewed: February 12, 1998
Article ID: Q165493
The information in this article applies to:
  • Microsoft Excel 97 for Windows

SYMPTOMS

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.

CAUSE

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.

RESOLUTION

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.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

The following steps demonstrate the issue described in the "Symptoms" section:

  1. Open a new worksheet and enter the following in Sheet1:

    A1: this is rich-text

  2. Double-click cell A1 to activate in-cell editing.

  3. Highlight just the "rich-text" portion of cell A1, and then click Cells on the Format menu.

  4. In the Format Cells dialog box, click Bold in the Font Style list, and then click OK.

  5. Press ENTER. Note that the "rich-text" portion of cell A1 is bold.

  6. Select cell A1, and then click Conditional Formatting on the Format menu.

  7. 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" (without the quotation marks) in the RefEdit box to the right of the second drop-down box.

  8. 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.

  9. Click OK in the Conditional Formatting dialog box.

NOTE: Only the "this is" portion of cell A1 is changed to Red.

REFERENCES

For more information about Conditional Formatting, click the Index tab in Microsoft Excel Help, type the following text

   Conditional formats

and then double-click the selected text to go to the "Highlight data that meets conditions you specify" topic.


Additional query words: XL97
Keywords : xlformat xlui kbbuglist
Version : WINDOWS:97
Platform : WINDOWS
Hardware : x86
Issue type : kbbug


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 12, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.