Formula link RGB Symbol to automatically update according to Number

chris.italiano78351

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

Connor Hartford

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

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

chris.italiano78351

Perfect Connor, thanks heaps!

Exactly what i wanted & appreciate the quick response 👍👍

Stay safe