Posted 8 September 2017, 1:14 pm EST
I want to detect all the rows with a particular row that has same ItemID, and trying to change the color of that row(for example). In the spread there may be many records with same ItemId. If I am changing the back color of ItemID 123 , then all rows with ItemId 123, should reflect the action.
I can loop through all the row and can compare the Itemid fileld, then change the backcolor. But I do not want to use the loop as there may be 999999 rows which may become a performance issue.
Any other way to achieve the same?