Hey @harsh2 for this logic use 2 read range and save their output in dt1 and dt2 now use two for each row and inside for each use one if condition and inside if pass if currentrow1 = currentrow2 → in then branch use set color range or for comparing you can this logic also for this logic you dont need two for each.
dt1.AsEnumerable().Where(Function(r)r(2).ToString().Trim=CurrentRow(2).ToString().Trim)
