Formula link RGB Symbol to automatically update according to Number
Good Morning
I have another formula question, i was hoping i can get some help.
I would like to make the below RGB Symbol change according to the number below.
E.g. I would like the below yellow Symbol to change when the 0.2 number changes
The rules i would like to set are:
Green: 0 and above(anything positive)
Yellow: 1 to 10
Red: 10 and Greater
Thanks
Best Answer

Hi chris.italiano78351,
The RGB balls are referenced by the name of the color, when used in a formula. (i.e. "Green", "Yellow", "Red", "Blue").
In the RGB cell, you'll want to have a formula like this:
=IF([+/]3 >= 0, "Green", IF(AND([+/]3 < 0, [+/]3 > 10), "Yellow", IF([+/]3 <= 10, "Red", "")))
I assumed the row with "Deposits" was row 1, "Best Bin" was row 2, and "Actual Bin" was row 3. Adjust the formula to reference the correct row if my assumption is incorrect.
Hope this helps,
Connor
Connor Hartford
Answers

Hi chris.italiano78351,
The RGB balls are referenced by the name of the color, when used in a formula. (i.e. "Green", "Yellow", "Red", "Blue").
In the RGB cell, you'll want to have a formula like this:
=IF([+/]3 >= 0, "Green", IF(AND([+/]3 < 0, [+/]3 > 10), "Yellow", IF([+/]3 <= 10, "Red", "")))
I assumed the row with "Deposits" was row 1, "Best Bin" was row 2, and "Actual Bin" was row 3. Adjust the formula to reference the correct row if my assumption is incorrect.
Hope this helps,
Connor
Connor Hartford

Perfect Connor, thanks heaps!
Exactly what i wanted & appreciate the quick response 👍👍
Stay safe
Help Article Resources
Categories
Check out the Formula Handbook template!