I have implemented a simple workflow to get a cell color using “get cell color” activity from column “A” and write the color name using “write cell” activity in column “B”.
But unfortunately, “get cell color” activity always give me white and don’t write the exactly color in the cell.
Here is my Excel:
And here’s my Workflow:
Can anyone tell me how to solve this issue?
Colors.xlsx (8.6 KB)
Main.xaml (13.7 KB)
It seems GetCellColor doesn’t support ConditinalFormatting at this time.
We have no way but find any other approach, I think.
Can try with the Get Cell color to some particular cell like A1. Just try with a sample excel and check it.
I have tried it and it’s working but Whenever I have clicked on conditional formatting in Excel, Unfortunately it doesn’t work as expected and that’s my question.
How can I read color if the cell is conditional formatting ? @Rahul_Unnikrishnan
Can you please tell which approach can work with my case?