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

Help Studio
, ,
2

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

CurrentRow("ColumnName").ToString.Equals("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

https://docs.uipath.com/activities/other/latest/user-guide/excel-set-range-color

Regards
Gokul