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:
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!