Read font colour in a cell containing multiple font colours

I have a spreadsheet I’m working on that my client uses by entering multiple values into a single cell and then coding their status by colour. Cells, for example, could look like:
cells

I need to be able to identify the individual colours within a single cell. The Get Cell Colour activity doesn’t capture font colour. And I’ve found custom VBA code that identifies font colour within a cell, but it only identifies correctly if there is a single font colour.

Does anyone have any suggestions? Thank you!

Hi @gpd821
Use get cell color within excel application scope and check the range as mentioned and check the color by below syntax and check it

setcolor.Name.ToString

Thanks
ashwin S

Hi Ashwin, thanks for the reply.

The Get Cell Color activity only returns the color of the cell, not the text.