Conditional higlighting

[A_Learner]

Hi,
Is it possible to conditional highlight in Excel or data table when a cell matches lowest or highest value.

[Yoichi]

Hi,

Can you try the following sample?

indexesMax = dt.AsEnumerable.Where(Function(r) CDec(r("Value"))=dt.AsEnumerable.Max(Function(r2) CDec(r2("Value")))).Select(Function(r) dt.Rows.IndexOf(r)).ToList()

Sample
NewBlankTask20241119-1.zip (57.4 KB)

Regards,