Excel 2007 - 条件格式：字体恢复为 Cambria
每当我使用条件格式时，字体就会更改为 Cambria（大小 10 或其他）。我无法使用[主页、条件格式、管理规则、编辑规则、格式、“字体”]选项卡更改字体及其大小。一切都变灰了！看起来像一个错误？我在网上看到过有关此问题的帖子，但没有答案。现在怎么办？
（另外，我使用的是 Windows XP SP2。几个月后我们将升级到 Windows 7，这可能会让问题消失。）
Whenever I use conditional formatting the font changes to Cambria (size 10 or something). I can't change the font nor its size using the [home, conditional formatting, manage rules, edit rule, format, 'font'] tab. It's all greyed out! It looks like a bug? I've seen posts on this on the web but no answers. What now?
(Ps I'm using Windows XP SP2. We're going to upgrade to Windows 7 in a few months, which might make the problem go away.)
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（9）
解决此问题的方法是：
这将删除“字体”选项卡上的所有设置 - 至关重要的是，
包括字体本身，因此根本不选择任何字体。
等）然后它不会改变字体。
The way to fix this is :
This will remove all the settings on the Font tab - crucially,
including the font itself, so that no font is selected at all.
etc) and then it will not change the font.
这可能有点晚了，但我在寻找解决方案时发现了这个网站，所以也许其他人可以从这些信息中受益。
当您启用跟踪时，Office 2010 似乎也会禁用条件格式。就我而言，禁用跟踪解决了问题。然后，您可以创建条件格式并重新启用跟踪。
希望这可以帮助别人！
G
this may be a little late, but I found this site when searching for a solution, so maybe someone else can benefit from the information.
Office 2010 also seems to disable Conditional Formatting while you have Tracking enabled. In my case, disabling tracking fixed the problem. You can then create the conditional formatting and re-enable tracking.
Hope this helps someone out!
G
我已经有条件地格式化了一些单元格，并且我观察到了您所描述的行为。您只能更改：
我对单元格进行了条件格式化，如果单元格等于 10，它就会变成红色。
后来我返回并更改了单元格的常规格式，以便它们都是 Arial 12 点。 10 的单元格保持红色。
我不认为这是一个错误，而是一种更微妙的方式来鼓励您做出更好的字体选择。您可以在其下划线或将其变成红色，但 Excel 似乎不允许您将其设为 40 分 Haettenschweiler。
编辑：
您提到这些是您在 Excel 2007 中使用的 Excel 2003 电子表格。您是否将电子表格保存为 .xls 或 .xlsx 格式？您观察到的电子表格行为不一致可能是因为 Excel 试图保留 Excel 2003 行为所致。我建议您将其保存为 Excel 2007 格式 (.xlsx)，并查看条件格式是否效果更好。 （完整故事请参阅评论路径。）
I have conditionally formatted some cells, and I have observed the behavior you describe. You can only change:
I conditionally formatted the cells so that it turned red if the cell equals 10.
I later went back and changed the regular formatting of the cells so that they were all Arial 12 point. The cell with 10 remained red.
I don't think this is a bug, but rather a more subtle way to encourage you to make better font choices. You can underline it or turn it red, but it seems like Excel won't let you make it a 40 point Haettenschweiler.
Edit:
You mentioned that these were Excel 2003 spreadsheets that you are working with in Excel 2007. Have you been saving the spreadsheets in .xls or in .xlsx format? The inconsistent spreadsheet behavior you observe may be caused because Excel is trying to preserve Excel 2003 behavior. I recommend that you save it to Excel 2007 format (.xlsx) and see if the conditional formatting works better. (See comment trail for the full story.)
我实际上也遇到了同样的问题。感谢这个问题（以及其中的讨论），一些其他研究，以及一些在黑暗中随机刺探，我找到了一个“解决方案”。它不干净也不准确，我无法解释它，但它对我有用。希望它对其他人有用。
为什么条件格式被禁用：为了扩展rajah9的评论之一，讨论了无法在条件格式中更改字体的原因这里 写着：
另一位用户在此处回应：
所以，你不能这样做，因为 MS 不信任你。如果不是因为 MS 确实改变了它，那将是宜居的。
将电子表格保存为 .xlsx 格式是可行的，但我们中的一些人（包括我自己）必须支持 Excel 2003 用户。
我的设置：我目前正在使用 Excel 2010 以及在 Excel 2003 中创建的 .xls 文件。我注意到一个工作表中的条件格式公式意外地更改了字体，而另一个工作表则保持不变。这让我相信可以实现预期的行为。
解决方案：我创建了一个新的工作表。然后，我将旧工作表中的所有边框、文本、公式等复制并粘贴到新工作表中。另外，我重新制作了我最初需要的所有 CF。最后，我删除了旧的工作表，并用基本相同的新工作表取而代之。最后的结果是我的所有CF都工作正常并且没有改变字体！
这一切都是在 Excel 2010 中实现的，并保存为原始的 .xls 格式。每次更改后重新打开文件时，我的字体都保持不变。
如前所述，我无法完全解释它，但旧工作表似乎保留了导致这种不一致行为的某些内容，并在 2010 年重新创建它删除了隐藏的 gremlin。
I actually had the same exact problem. Thanks to this question (and the discussions in it), some other research, and some random stabbing in the dark, I came to a 'solution'. It's not clean and exact and I can't explain it, but it worked for me. Hopefully, it is useful for others.
Why Conditional Formatting is disabled: To expand on one of rajah9's comments, the reason you can't change font in Conditional Formatting is discussed here where it says:
Another user echoes here:
So, you can't do it because MS doesn't trust you with it. That would be livable if it weren't for that fact that MS DOES change it.
Saving the spreadsheet in .xlsx would work, but some of us, myself included, have to support Excel 2003 users.
My setup: I am currently working with Excel 2010 with a .xls file that was created in Excel 2003. I noticed the conditional formatting formulas in one worksheet undesirably changed the font, while the other worksheet left it alone. This led me to believe that the desired behavior COULD be achieved.
Solution: I created a new worksheet. Then, I copied and pasted any borders, text, formulas, etc. from the old worksheet into the new one. Also, I redid any CFs I originally needed. Finally, I deleted the old worksheet, with the new, essentially identical one, in its place. The final result was all my CFs worked properly and didn't change the font!
This was all achieved in Excel 2010 and saved as the original .xls format. Every time I reopen the file after this change, my font remains intact.
As mentioned, I can't quite explain it, but it seems the old worksheet maintained something that caused this inconsistent behavior and recreating it in 2010 removed the hidden gremlin.
我知道这是一个古老且可能已过时的主题，但对于遇到此问题的 Excel 2003 用户来说可能仍然很方便。就我而言，我使用条件格式根据
=mod(row(),2)=1或0为交替行着色。大多数时候，这工作得很好，但在一张纸上，它会导致交替行也有不同大小的文本（我相信是 8 和 10）。当我进入字体下的条件格式对话框时，文本大小如其他人所描述的那样呈灰色。但是，删除线选项已被选中。取消选中此选项可以解决问题。
我不确定为什么会发生这种情况，因为我没有在工作簿中的任何地方使用删除线。
I know this is an old and possibly obsolete topic but it may still be handy for Excel 2003 users encountering this issue. In my case, I was using conditional formatting to color alternating rows based on
=mod(row(),2)=1or0. Most of the time this worked fine but on one sheet, it was causing alternating rows to also have different size text (8 and 10 I believe).When I went into the conditional formatting dialogue under font, the text size was greyed out as others have described. However, the Strikethrough option was checked. Unchecking this fixed the issue.
I'm not sure why this happened as I didn't use strikethrough anywhere in the workbook.
我可能还找到了“解决方法”。我在“.xls”表上设置了 CF 规则，但返回的字体根本不是我想要的，并且我的其他规则没有遇到此问题。
所以我尝试了这个。 。 。 。我将 CF 规则保留在 B 列中，然后再次选择 B 列并使用“突出显示单元格规则”选项，而不是直接进入“新规则”选项。
我的选择是“包含的文本”。我在第一个框中输入了要查找的文本，在第二个框中选择了“自定义格式”。我取消单击删除线复选框（只是为了安全起见）并选择我想要的颜色。
我单击“确定”，字体和大小恢复为单元格最初的格式。
真的不知道为什么会起作用，但很高兴它起作用了。
I may have also found a "work-around". I have a CF rule in place on an ".xls" sheet, but the returned font face is not at all what I want and I have not had this problem with my other rules.
So I tried this . . . . I left the CF rule in place for column B, then I chose column B again and used the "highlight cells rules" option -- instead of going straight to the "new rule" choice.
My choice was "text that contains". I entered the text I am looking for in the first box, chose the "custom format" in the 2nd box. I unclicked the Strikethrough check box (just to be safe) and chose the color I wanted.
I clicked OK, and the font face and size reverted to what the cell was originally formated for.
Don't really know why that worked, but VERY glad it did.
在 Excel 2010 中，字体选项卡下有一个清晰的格式选项。我清除了格式，并删除了在我的设置中设置的默认 cambria。然后我可以修改可用选项，但灰色字体随后变为空白。
In excel 2010 there is a clear formatting option under the font tab. I cleared the format and it removed the default cambria that was set in my settings. I was then able to modify the available options, but the grayed out font was then blank.
我知道这个字符串很旧，但我只是必须写下并告诉大家：
条件格式。
这是无法改变的，而且看起来与 Calibri 非常不同。
是与结果的默认格式相关的错误
细胞的状态。
解决方案：
结论：
I know this string is old, but I just HAD to write and tell:
conditional formatting.
that cannot be changed and that looks very different from the Calibri.
is a bug assosiated with default format for the the outcome of
a condition of a cell.
Solution:
Conclusion:
我知道这可能是一个迟来的答案，但对于任何使用 excel 2007 工作的人来说，这都是一个相当简单的答案 - 我也遇到了这个问题，我想做的就是更改文本的颜色，但由于某种原因，excel 也将字体更改为坎布里亚。
在条件格式/编辑规则对话框中，我只需按下右下角的“清除”按钮，即可将文本恢复为纯黑色，没有粗体/斜体等。然后我立即重置我的规则，应用不同的颜色和粗体样式，按“确定”，然后这似乎起作用了。文本没有更改为 Cambria。
希望这对仍然遇到问题的人有所帮助。
I know this may be a belated answer but it's quite an easy one for anyone working in excel 2007 - I had this problem too where all I wanted to do was change the colour of the text but for some reason excel was also changing the font to Cambria.
In the conditional formatting/ edit rule dialogue box, I just pressed the 'clear' button in the bottom right corner which reverted the text to plain black with no bold/ italic etc. I then immediately reset my rule, applying a different colour and bold style, pressed OK and this then seemed to work. The text did not change to Cambria.
Hope this helps for anyone who is still having the problem.