For Every one want to have More color symbol for health Status column.

Bassam Khalil

Dear Community Memebers,

I saw many equations asking to have More color symbol for health Status column, so i added this post to be a simple reference to solve this issue and with your help and comments we can develop it to match the most of your wishes.

the following screenshot shows the color reference you can use it in your UNICHAR Function and a simple IF statement formula using those codes:

the Sample formula:

=IF(Color@row = "Orange", UNICHAR(128992), IF(Color@row = "Gray", UNICHAR(128280), 
IF(Color@row = "Red", UNICHAR(128308), IF(Color@row = "Blue", UNICHAR(128309), 
IF(Color@row = "Yellow", UNICHAR(128993), IF(Color@row = "Green", UNICHAR(128994),
IF(Color@row = "Purple", UNICHAR(128995)))))))) 

Genevieve P.

Hi @Bassam Khalil

Thank you for detailing your solution! I've moved this post into our Best Practice category.

Keep up the great work!

Genevieve

Bassam Khalil

@Genevieve P.

Thank you for your support.

Nero Naidoo

Thank you Bassam for always eing so helpful. You've made my job so much easier.

Abiola

This is a very useful information. Thank you Bassam.

Suresh Seetharaman

Thank You Bassam for your support. You have gone extra mile to help me find a solution. Thank you.