color scales

Hi there, I'm new to the forum. So please be gentle :) I'm trying to come up with a solution to have a column of numbers appear in a graded color sequence (similar to what the color scales in conditional formatting do), but have the high and low numbers used for the grading changed based on...

Hi, I'm fairly new to VBA. My question is I have a problem like this: <tbody> A B C 1 5% x 2 -7% x 3 10% y 4 20% x 5 11% y 6 -32% x 7 1% x 8 -3% x </tbody> This is a block of data (A1:B8) and I want to conditional format all those % with 3 color type...

Hello, I would like to use Excel color scale to do a conditional formatting on some cells. If the cell value < 0 --> cell color is red If 0<=cell value <1 -> cell color is a gradient chaging from red to yellow If the cell value is 1 --> cell color is yellow If 1< cell value is <=2 --> cell...

Hello, I am hoping someone can help me figure this one out. I have a sheet with a list of numbers on it (numbers can be 1-50): Example: <tbody> 1 2 3 2 2 3 2 2 1 3 1 2 1 1 2 </tbody> and another sheet in the same workbook which I have set with COUNTIF to count the number of times a...

I am trying to have conditional formatting color scale "Green - White - Red" be used when I have "Nominal" values selected in my pivot tables, but when "Rank" is selected I would like the conditional formatting color scale to be "Red - White - Green". Any ideas? Thank you!

Hi all, I was wondering whether it is possible to apply a color scale (red [low] - white - blue [high]) based on a nxn matrix to a different, distinct nxn matrix. If its not possible, can anyone think of a clever way to do this? Right now I am defining 10 distinct custom rules, which apply...

I am a first time poster, so not sure if this is where this question belongs. I have Excel 2013 (and 2010) installed and know how to do color scales and how to do custom formulas but here is my delimma and not sure if it's possible. I have an excel with >50 columns of data, each column is an...

Hi folks. So I have a sensitivity table that changes dynamically depending on user inputs into my model. Basically what I want to do is to have 2 different sets of color scales applied to the data. For any number that is negative I want to use a white/red color scale. For any number that is...