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

Bassam KhalilBassam Khalil ✭✭✭✭✭
edited 07/30/21 in Best Practice
07/30/21 Edited 07/30/21

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([email protected] = "Orange", UNICHAR(128992), IF([email protected] = "Gray", UNICHAR(128280), 
IF([email protected] = "Red", UNICHAR(128308), IF([email protected] = "Blue", UNICHAR(128309), 
IF([email protected] = "Yellow", UNICHAR(128993), IF([email protected] = "Green", UNICHAR(128994),
IF([email protected] = "Purple", UNICHAR(128995)))))))) 

PMP Certified

[email protected]

www.mobilproject.it

☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Comments

Sign In or Register to comment.