Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/924186

From BetaArchive Wiki
Knowledge Base


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 "Late" to appear in red when a task is past its due date. However, when that condition is met, only the letter "L" appears in red. The letters "ate" 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