How do I highlight an Excel row based on a column condition?

Hello All,

I have an Excel sheet. How do I highlight the row, which is remarked as “Duplicate” ?


Hi @jijorhohim98

You need to use set range color and pass the row range to it and it will set the color. run a for loop after reading into datatable to get and identify the duplicate keyword

Uploading: image.png…

use the index in for each to get the row count.