5 Replies Latest reply on Mar 29, 2020 1:15 PM by Soumitra Godbole

# How can i give a field a color based on a number from a different field?

Hi,

I have a question. I have 2 fields. 1 field is called "team" with a list of all the names of teams and another field is named "grade" with all grades.

How can i turn "team" into red if they score below 5.5 and above 5.5 green? so lets say Team Mickey gets turned green when their grade under "grade" contains 8

• ###### 1. Re: How can i give a field a color based on a number from a different field?

Are you just trying to change the color of the text? Any chance you can share a packaged workbook so we can see the data and it's structure?

• ###### 2. Re: How can i give a field a color based on a number from a different field?

Hi Rockey,

Here is a simple solution along  with the twbx file and excel spreadsheet (attached below).

In addition to the simple Red and Green color you requested (based on whether the Grade was

greater than 5.5 or not), I have added a Score Color formula that adjusts the Red and Green

shades (a bit shady ) depending on how much higher or lower the grade is in comparison to

the set value of 5.5.

Hope this was helpful, entertaining and visually appealing. Let me know if you have any questions.

Best Wishes !

Sincerely,
Soumitra

• ###### 3. Re: How can i give a field a color based on a number from a different field?

Hi Soumitra,

First of all, thanks for the help and the solution you gave to me. I had 2 more questions. If i wanted to use 3 colors like red for everything under 5.5, orange for 5.5 and green for everything above 5.5, how would this be possible? I see with editing colors you could only pick 2 colors and it automatically changes the color in between. And what does the calculation actually say? The average of field "grade" - 5.5  and then divided by 4.5?

2nd is there a way to color team like Donald/mickey/goofy red/orange/green depending on the grade?

Thanks!

1 of 1 people found this helpful
• ###### 4. Re: How can i give a field a color based on a number from a different field?

Hi Rockey

You're welcome ! Sure you can get several colors as per your requirement. The formula

I posted earlier was something new I was trying out to get a bit more color depth. Usually

most folks prefer one color for a bucket range and it works fine in most cases but sometimes

it does look monotonous. Also your original question only requested >= 5.5 and < 5.5.

What I was trying to do using this formula was to show different shades of 2 colors (Red

and Green) depending on how far the Grade was from 5.5. Let's say Donald (Duck) had

a score which was slightly below 5.5 (say 5.3) then we would see a light red. Goofy really

goofed up and his score was only 3.3 so you see a darker shade of Red. Similarly if Pluto

only made a 6.0 then he would have a lighter shade of Green.

Anyway you have now given me more colors constraints so I updated the Grade Color :

As far as the 2nd part goes, "yes we can" (color the image and the Team Name). All we

have to ensure is that the image has a transparent background (png file) and not white

as I had it in your earlier solution (Office365 Powerpoint and other useful graphic tools

like GIMP allow you to make the background transparent). Finally here is your new visual

(after slightly modifying data)

For your reference, I have attached the Enhanced Solution twbx file along with the updated

data file. Do let me know if you have any further questions or need any modifications. I hope

this exercise was helpful, visually appealing and entertaining. Best wishes and take care !

Sincerely,
Soumitra

• ###### 5. Re: How can i give a field a color based on a number from a different field?

On a lighter note, it's  a great thing you did not select "Yellow" as one of the colors.

The last thing any Team or player wants is to be called "Yellow" (coward) .

Also I hope Mickey's journey into outer space to find Pluto was successful.

Best Wishes !

Sincerely,
Soumitra