can you please guide with me , how to set colour in particular cell range in excel , dynamically. for example verified should be in green colour and not verified should be in red colour , so verified and not verified will be in different cell . so according to that the colour should be set.
use Read Range activity to read data from Excel and will give you output as dataTable.
Then use For Each Row activity to itreate that dataTable.
ForEach row in dataTableName
Int Index =
Then use Set Range Color activity and specify color and cell range.
If it is ‘C’ column then range should be “C”+index.Tostring