How to highlight cell colour in excel if column contains specific value like yes?

For example I have a column Status with values (yes/no)
Those having no values need to be highlighted in yellow colour.
How can we achieve that?

Hi @vnsatyasunil

Try it out the following steps

  1. Use the Read Range activity to read the Excel file and store the data in a Data Table variable,

let’s say dtExcelData

  1. Use a For Each Row activity to iterate through each row in dtExcelData.

  2. Inside the For each activty, use an If activity to check if the specific column contains Yes

  1. If the condition is true, use the Set Range Color activity to highlight the cell
Range : "A" + (CurrentRow.Table.Columns.IndexOf("ColumnName") + 2).ToString

Check out the document


Hi @vnsatyasunil,

You could also create an excel template with all the conditional formatting you need and then use that template to write output.

tried this working fine for one datatable.In retry number of activities after extracting if I use set range colour for filtered data table other than filtered rows also highlighting with colour. But in extracted datatable those rows are not there.will it work in retry number of times activity?

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.