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:D3 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:D3 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.