Colour condition

[poojaskyrathore]

i have a condition where in a column if there is false the cells has be in red in colour . what condition do i give in if condition?

[Sudharsan_Ka]

Hi @poojaskyrathore

Checkout this thread

How to mark color in particular cell value in excel

Hi @Raja.G - Here you go… [image] Set Range Color Properties [image] Here idx is Int32 varaible which starts with 0 by default. That’s why i have +2 to get the exact row. Output [image]

To set color to a specific cell in excel based on condition

Hi All, Am trying to match the values from Sheet1 and Sheet2, if the Sheet1 values in all columns matching with Sheet2 have to insert a new column named ‘status’ in Sheet1 and update as ‘Match’ with green color. If any value in the particular column is not matching, that needs to be marked with ‘yellow’ color and ‘status’ value should be updated as ‘NoMatch’ with Red color. Have attached the sample excel. Please assist with above workflow or sample, i tried few types, however am able to matc…

Regards
Sudharsan

[Vamsi_Krishna_Gogineni (Vamsi)]

Hi @poojaskyrathore, if you’re asking for the condition to check if cell has ‘False’, please use below.

If you’re looping through each row in DataTable using ‘For Each Row in Data Table’ activity, you can use CurrentRow.Item(“YourColumnName”).ToString.ToLower.Equals(“false”). And, if you’re looking for how to color the cell, you may follow the steps provided by Sudharsan above.