CODEWITHSUNDEEP
excelconditional-formatting
Mr. Buster
Mr. Buster

Reputation: 131

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.

enter image description here

And I want to make it like this.

enter image description here

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.

Upvotes: 2

Views: 1021

Answers (1)

user4039065
user4039065

Reputation:

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

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

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

enter image description here

Upvotes: 5

Related Questions