如何根据其值更改单元格的格式和文本。 （条件格式） [英] How to change the formatting and Text of a cell based on their values. (Conditional Formatting)

问题描述

我想根据其值更改单元格的填充颜色和文本。假设我具有以下值。

Hi I want to change the Fill color and text of the cell based on its value. Let's say I have the below values.

我想这样。

对我来说，填充颜色将很容易，因为我将进行条件格式设置。但是，文字使它变得很难。像上面的示例一样，如何将单元格值更改为Text。谢谢。

For me the fill colors would be just easy because I will just do the Conditional formatting. However the text is making it hard. How can I change the cell values into Text like the example above. Thanks.

推荐答案

为颜色创建条件格式设置规则，然后点按ctrl + 1并应用以下自定义数字格式。

Create your conditional formatting rule(s) for the colors then tap ctrl+1 and apply the following custom number format.

[>10]\G\r\e\at\e\r 1\0;[<=10]L\e\s\s 1\0

如果要将所有更改都放在一个位置，可以将其与颜色填充更改一起放入CFR中。

You could put that in the CFR along with the color fill change instead if you want to keep all changes in one place.

请注意，您尚未更改单元格的值。 = SUM（Z：Z）仍等于61。

Note that you haven't changed the cells' values. =SUM(Z:Z) still equals 61.

这篇关于如何根据其值更改单元格的格式和文本。 （条件格式）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！