I create reports with different cohort tables. Each row of a table must have conditional formatting with color scale (depending only on current row values, i.e. regardless of other rows min/max values). Are there possibilities (in the GUI or using some scripts) to make such formatting quickly?
At the moment, I add conditional formatting rule for each rows independently, it is very tediously and time-consuming!
I tried to find a solution on this and other websites, but found no such questions. I hope an answer exists, and someone will share it.
Update
What I need is creating multiple different color scale ranges on different rows independently but simultaneously:
Update 2
@OrenPinsky's solution is almost perfect! However, it takes only initial position for formatting and then goes down through all the rows until a blank one. It doesn't use selected row width, nor table height. So, better answers will be considered and appreciated as well.