I have a color based chart, and want to make a button which will blend all the selected cells (With.Selection.Interior) by creating a gradient based on the cells on the right and left of the selected cell. For example,
Cell B4=Yellow
Cell B6=Red
I want cell B5 to be a gradient from yellow into red. This will all be activated by a button, no need for automation.
**To clarify, the adjacent cell colors will already be selected manually by the user.
I have tried several different ways of going about it, but the bottom line is I can't set cell colors based on relative cells. Thanks in advance.
(I cannot attach the chart for proprietary reasons, sorry)
Bookmarks