Microsoft KB Archive/924186

= Excel may apply conditional formatting only to the first character or to the first few characters of a string instead of to all the characters of a string =

Article ID: 924186

Article Last Modified on 10/10/2006

-

APPLIES TO


 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 2000 Standard Edition

-



SYMPTOMS
You set conditional formatting for a string in a Microsoft Excel spreadsheet. However, Excel may apply the conditional formatting only to the first character or to the first few characters of the string instead of to all the characters of the string. For example, you want the word &quot;Late&quot; to appear in red when a task is past its due date. However, when that condition is met, only the letter &quot;L&quot; appears in red. The letters &quot;ate&quot; do not appear in red.



CAUSE
This behavior may occur if the string has more than one font style. For example, the first character or the first few characters of the string have a font size of 14. The other characters of the string have a font size of 10. Excel will apply the conditional formatting to only the first font style. The style to which Excel applies the conditional formatting is always the style that is used for the first character or for the first few characters of the string.



STATUS
This behavior is by design.

Additional query words: Excel2000 XL2000 Excel2002 XL2002 Excel2003 XL2003 XL2K3

Keywords: kbtshoot kbprb KB924186

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.