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.
嗨我想根据其值更改单元格的填充颜色和文本。假设我有以下数值。
And I want to make it like this.
我想这样做。
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.
对我来说,填充颜色很简单,因为我只会进行条件格式化。然而,文本正在变得艰难。如何将单元格值更改为文本,如上例所示。谢谢。
1 个解决方案
#1
5
Create your conditional formatting rule(s) for the colors then tap ctrl+1 and apply the following custom number format.
为颜色创建条件格式设置规则,然后点击ctrl + 1并应用以下自定义数字格式。
[>10]\G\r\e\at\e\r 1\0;[<=10]L\e\s\s 1\0
You could put that in the CFR along with the color fill change instead if you want to keep all changes in one place.
如果要将所有更改保存在一个位置,您可以将其与颜色填充更改一起放入CFR中。
Note that you haven't changed the cells' values. =SUM(Z:Z) still equals 61.
请注意,您尚未更改单元格的值。 = SUM(Z:Z)仍然等于61。
#1
5
Create your conditional formatting rule(s) for the colors then tap ctrl+1 and apply the following custom number format.
为颜色创建条件格式设置规则,然后点击ctrl + 1并应用以下自定义数字格式。
[>10]\G\r\e\at\e\r 1\0;[<=10]L\e\s\s 1\0
You could put that in the CFR along with the color fill change instead if you want to keep all changes in one place.
如果要将所有更改保存在一个位置,您可以将其与颜色填充更改一起放入CFR中。
Note that you haven't changed the cells' values. =SUM(Z:Z) still equals 61.
请注意,您尚未更改单元格的值。 = SUM(Z:Z)仍然等于61。