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?
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 !
1 of 1 people found this helpful
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?
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 !
Rockey's Data.xlsx 9.5 KB
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 !