May I ask how I can use write cell or other activities to extract specific highlighted data from sheet ‘2.1 Summary’ to target output sheet in accordance with the same highlighted color.
Hie @Happydayyy , It seems like you are using workbook which doesn’t have indirect manipulation of color. You can use the Use Excel Activity which allows you use an activitities like Get Cell Color to allow you check color for each cell for each Role.
No you cannot use write cell to extract but you can Get Cell color, Check if cell color is matching you targeted, then you read the value of the cell.
Hope this will assist you.
Regards
Hi Happydayyy,
I honestly dont know what are you trying to do, but you can see the columns name were modified after you apply the business rules. Try to check the business rules because you are modifying the column names into the for each activity.
Hope Helps you!