Conditional gradient style for irrelevant in the condition cells

asked 2020-01-05 02:45:11 +0200

halloo gravatar image

updated 2020-01-07 09:12:01 +0200

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

image description

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 image description

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

range: A1:B9;D1:D9

=$D1=1

=$D1=9

image description

having just one style, something like:

range: A1:C9

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

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

image description

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

edit retag flag offensive close merge delete

Comments

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

image description

Mike Kaganski gravatar imageMike Kaganski ( 2020-01-07 10:05:17 +0200 )edit

@Mike 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:

image description

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)

halloo gravatar imagehalloo ( 2020-01-10 20:52:31 +0200 )edit