# 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

But how could it differentiate with e.g. this:

@Mike2 in your example the conditional style just looks at the value of every cell relative to all other values in its cell Range.

But I need is to color the rows the same color, for example:

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)