# Conditional gradient style for irrelevant in the condition cells

I want to essentially link the style of other cells in the same row to a specific column. So that the entire row is colored the same color.

all cells -> color scale(3 etnries) applied to:

range: C1:C9

I'm trying to color the rows on the left(text&number) with the same color either by:

range: A1:C9

=RANK($C1;$C$1:$C$9)=1 =RANK($C1;$C$1:$C$9)=9

OR I've tried another way by moving the range() formula into a separate column:

range: A1:B9;D1:D9

=$D1=1 =$D1=9

having just one style, something like:

range: A1:C9

=MIN($C$1:$C$9)

=MAX($C$1:$C$9)

does the same thing in one style, but not the entire rows

edit retag close merge delete

The only relevant for the coloring style condition column is "rank" (Cell Range = D2:D7), the relations of values in this column represents that gradient color, the values in D2:D7 are calculated with: =RANK(C2;$C$2:$C$7;1) function. ("rank" column represents color, I've added it for simplicity, so ideally I'd want it to just be in a formula somewhere, leaving only color)