3 color scale

[shaftdx]

I am having a problem with the 3 color scale. I have several rows of data that I want to use the 3 color scale for. However when I apply it it goes to the entire group and not the individual row.

for example if I am not being clear with what I mean Row#3 has 3 prices $300 $350 $250 I want the lowest to be green middle orange and highest red for that row. The way it is working now if row #4 has anything lower or higher then what is in row 3 it counts them as well. How can i get it to work for each row individually?

 

[Fluff]

You need to apply the CF to each row individually.

 

[shaftdx]

You need to apply the CF to each row individually.

crapola...I was afraid of that. Thank you for confirming that.

 

[Fluff]

Sorry I didn't have better news

 

[shaftdx]

Sorry I didn't have better news

it is ok, it is not really NEEDED for this sheet but more of a vanity thing like "Look what I can make this do!"

 

[Fluff]

You could use a macro to add the CF to each row.

 

[shaftdx]

You could use a macro to add the CF to each row.

I do not know how to do that

 

[Fluff]

Turn on the macro recorder & then manually apply the CF to the first row in the data & post the code you get.