Could you give an example of how to change the format of other cells in the same row and other rows when the user clicks on a cell.
The use case is as follows:
In a dating app I would like the administrator to select a match for each partner in the grid.
Each row of the grid contains the following fields, where the partner fields represent the partner that needs to be matched and the "Match" fields represent the best 3 potential matches that the system has identified:
Partner_Id, Partner_Name, Match1_Id, Match1_Name, Match2_Id, Match2_Name, Match3_Id, Match3_Name
When the admin clicks on either the Match_Id or the Match_Name field, I would like both fields to be highlighted and other rows that contain the same match to become greyed out (not disabled, just change background color).
How can I achieve this?
