How to get text color from excel

Hi Ui Path,

I have data as below in excel

Name Color
ABC
XYZ
123
456

where ABC text is in red, XYZ text is in Yellow,123 text is in Green and 456 text is in Blue color, i want to get text color names in Color column.

Any help or Guidance!

Thank you,
Mirza

Hi @Mirza_Hussain

Have a look on the docs

Regards
Gokul

Hi,

Thank you for the link!

I can get cell color using the above link, may I know how can I get color of text in the cell, in the below image I got color of cell “Name” and “Color”.

image

I need to get color of text written in “A2:A5” Cells in Color column.

Thank you,
Mirza

Hello @Mirza_Hussain
Kindly refer this flow, It may helps you
Forum_CellColour.zip (74.6 KB)

Regards,
Gokul Jai

Hi @Mirza_Hussain

Look ingto the video link

Regards
Gokul

Hi @Mirza_Hussain

Have a look on the BalaReva Activity

Regards
Gokul

1 Like

Hi

Can you please help me showing with workflow for the data I have copied in this topic, as I am a beginner its hard to built a workflow with VBA activity.

Thank you,
Mirza