When you format a cell with conditional formatting, and then format the first character in the cell with another format (such as a different font size, color, or underline), the rest of the letters may lose the conditional formatting.
↑ Back to the top
This behavior can occur when you change the format of the first character in a cell with conditional formatting, as in the following example:
- Start Excel, and then type One in cell A1.
- Select cell A1.
- On the Format menu, click Conditional Formatting.
- In the first box under Condition 1, click Cell Value Is.
- In the second box under Condition 1, click equal to.
- In the third box under Condition 1, type One.
- Click Format.
- In the Color box, click Red, and then click OK twice.
Note that the word "One" in cell A1 is red. - Select cell A1, and then select the letter "O."
- On the Format menu, click Cells.
- Under Font style, click Bold, and then click OK.
Note that the letter "O" is bold and red, but that the letters "ne" are now black (they have lost their conditional formatting).
↑ Back to the top
To work around this issue, use cell formatting to restore the look of the conditional formatting when conditional formatting is lost.
↑ 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