How would you Excel gurus do this?
I set the background color of a cell to be of a certain color by using basic functionality in the "Home" tab.
I now want the cell adjacent to it to be 10% lighter, and the next cell along to be 20% lighter, etc.
So if the first cell is coloured a dark red, the rest of the cells progress through rose-pink to pale skin color until they fade out to white. If I set the first cell to a dark blue color, the rest will progress from navy, to sea-ish to sky blue.
I'm guessing you can't do this without some VBA scripting, but better still if you can.
If VBA is required, how would I code this?
Thanks,
I set the background color of a cell to be of a certain color by using basic functionality in the "Home" tab.
I now want the cell adjacent to it to be 10% lighter, and the next cell along to be 20% lighter, etc.
So if the first cell is coloured a dark red, the rest of the cells progress through rose-pink to pale skin color until they fade out to white. If I set the first cell to a dark blue color, the rest will progress from navy, to sea-ish to sky blue.
I'm guessing you can't do this without some VBA scripting, but better still if you can.
If VBA is required, how would I code this?
Thanks,