Mar 31 2022 06:05 AM
I know I can use a gradient for a column but I'd like that each row is colored based on the color of the second row
Mar 31 2022 06:33 AM
Conditional formatting with color scales, icon sets or data bars only works on the cells with the values; there is no way to extend it to other cells.
You'd have to create multiple rules of type 'Use a formula to determine which cells to format', one for each color.
For example:
Mar 31 2022 07:54 AM
That's too bad, in my case this manual set won't be suitable. Anyway, thanks for the reply