J
JGPatrick
Is there any way in VBA to apply a colorscale, icon set, or databar to a
range, but have the color scale, icons, and databars show up in a different
range?
For instance, suppose in B1:B3 you have the number of sales of Robert, John,
and Sue, and in C1:C3 you have the dollar value of those sales, and that in
D1
3 you want to represent the number of sales with a color scale and the
dollar value of sales with an icon set. In other words, in D1
3 you want a
visual representation of the dollar value of sales overlayed on a visual
representation of the number of sales.
This is a toy example, I have a more complex application in mind.
range, but have the color scale, icons, and databars show up in a different
range?
For instance, suppose in B1:B3 you have the number of sales of Robert, John,
and Sue, and in C1:C3 you have the dollar value of those sales, and that in
D1
dollar value of sales with an icon set. In other words, in D1
visual representation of the dollar value of sales overlayed on a visual
representation of the number of sales.
This is a toy example, I have a more complex application in mind.