Need to find out Color Code value of Green, Orange and Red

[mpraka]

Hi All,

I have created a calculated column for Background color based on Status value. Provided the formula below:

Assignment Status BG = SWITCH(Table1[Assignment Status],"Complete","Green","Incomplete","Orange","Overdue","Red")

Now i want the actual color values of green, orange and red to put it in the another pie chart. Wants to make sure the colors are same throughout the report.

I would like to know the color values in this format - "#000000" like this for Green, Orange and Red.

Thank you

Prakash M

[olgad]

Hi There,
if i want to know what this blue color is, i click on color then more colors

is that what you are looking for?

[mpraka]

Hi @olgad ,

No. Actually that is the right way to find but my question is little tricky.

I have created one calculated column and given a switch function like if it is Completed then "Green".

So when i type "Green" in formula bar i don't know what is its exact value. So the green color populates at the back ground in matrix.

Now i would like to apply that same green color in pie chart. But in pie chart i have to give something like #23EA23 like this, i cant type text "Green" in pie chart. So i would like to know that exact value of Green, Orange and Red color to give it in pie chart.

If i make this question easier then --> what is the exact value of "Green" which i typed in formula bar and i want to know that color value in this format -- > #000000

Thank you

Prakash M

[v-stephen-msft · Accepted solution]

Hi @mpraka ,

Green: #008000

Orange: #ffa500

Red: #ff0000

Hope it helps you.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.