Save the details if the condition is met and highlight with yellow color

[Manju_Reddy_Kanughula (Manjunath)]

Condition row("T/O Cr").tostring>=20

Note 20 value coming from Queue.

when condition is met the T/O Cr column value should highlight with yellow color written in different excel .
input_file.xlsx (8.8 KB)

[Krishna_Raj]

@Manju_Reddy_Kanughula

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

Hi @vnsatyasunil Try it out the following steps Use the Read Range activity to read the Excel file and store the data in a Data Table variable, let’s say dtExcelData Use a For Each Row activity to iterate through each row in dtExcelData. Inside the For each activty, use an If activity to check if the specific column contains Yes CurrentRow("ColumnName").ToString.Equals("Yes") If the condition is true, use the Set Range Color activity to highlight the cell Range : "A" + (CurrentRo…

check the reference