Change of Symbol Value Colors

maltaee

Hello-

Is there a way to change the colors in these selections? e.g., I want to have "Orange" instead of "Yellow" and "Dark Green" instead of "Blue."

=IF(Outcome@row = "Zero", "Red", IF(Outcome@row = "Check Minus", "Yellow", IF(Outcome@row = "Check", "Green", IF(Outcome@row = "Check Plus", "Blue"))))

JamesB

@maltaee

The best way around this is to use a drop down list and CHAR/UNICHAR.

maltaee

JamesB

Oct 9, 2023

@maltaee

The best way around this is to use a drop down list and CHAR/UNICHAR.

https://us.v-cdn.net/6031209/uploads/NMY7G7SXF2PU/image.png

Thanks. Can this trick show only the symbols?

JamesB

Yes, I just added wording for my use case.

Here is the site I refer to for symbols.

https://www.vertex42.com/ExcelTips/unicode-symbols.html

maltaee

How do you list it in the drop-down list?

JamesB

I copy and paste the symbol in the Drop-down list and in my formula

IF([Blocked/On Hold]@row = "⚠️ On Hold"