How to check if a column of datatable(Excel) contains a value and highlight it?

[Gokul001 (Gokul Balaji)]

HI @Pruthvi.G

You can try with Lookup DataTable

Try this expression

DtMaster.AsEnumerable.Select (Function(x) x("University").ToString.Trim.Contains("IIT Madras")).ToArray()

Have a look on the thread for Highlighting

Fill excel color / highlight cells

Check this Color Excel

Regards
Gokul