Get Cell Color - To get exact color name

Help Activities
,
1

Hi,

I am trying to get the colors from excel and have to validate based on the color name using the if condition. I can able to get a few color names and a few colors with the code. Is there any way to convert the colors code into Color Name?

image
image1099×194 8.3 KB

image

image

image

1 Like
2

you cant get the name for every colour,
so you can do this instead: get R/G/B values for your colour variable and put in dictionary

image
image898×36 2.89 KB

image

then find the dictionary Key with the greatest value. That key = your colour
Key can either be Red/Green/Blue

e.g. dictionary is

"Red":50
"Green": 100
"Blue": 200

then your result will be Blue

see this for an example
a.xaml (12.3 KB)

3

It’s not matching Correct, it’s producing an incorrect color name. It’s differentiate only red, green, and blue not other colors.

image

image
image808×1002 15.6 KB

4

Hi @SrenivasanKanna , Can you please share the sample excel file of color codes?

5

Sample.xlsx (8.7 KB)