If a row value is “Reject” change that text color to red and related column “Remarks” also needs to be changed.
I have gone through previous topic not much of help, please help
Have you tried set range colour?
That should work perfectly fine. Just Loop through the data in Excel, based on the required condition you can colour the desired cell. below video shows the working.
The corresponding remarks column can be updated simply by assigning the text that needs to be added using an assign activity
Please mention your specific issue if thave tried above-mentioned method already.
Yes, i tried, it’s changing cell background color but i need text color to change
Okay, below thread has a workflow to do so. If you are not allowed to use the marketplace packages then you will have to go with ba vb script. Below link will show step to create a vha that can be run using Invoke VBA activity
thank you i tried first one, but couldn’t change.
second one cannot open link.
Means you used Bala’s marketplace activity already?
And still it didn’t work?
Oh, accessible to me though
Editing for correcting the wrong link
Below link is the similar one
Hope the below steps would help you resolve this
This involves two part where first one is to find the row in column REMARKS has that value as Reject and then second part is to color that row and column
First use a excel application scope and pass the file path as input and use read range activity and get the output as dt
Then use a for each row activity and pass dt as input
Inside the loop use a IF condition like this
- If it’s true it goes to THEN block where use this custom component
Where if it asks for cell position we can find that with row index
For example to find A4 cell position from row index
Convert.ToChar(65+dt.Columns.IndexOf(“column name”)).ToString + (dt.Rows.IndexOf(CurrentRow)+2).ToString
This will give the exact cell position