shawthingz
New Member
- Joined
- Aug 19, 2006
- Messages
- 49
Hi Folks,
Here's a problem I'd like to be able to solve in VBA:
Retrieve the current cell color (let's say A1 = 'green')
Format A1's cell colors (using the VBA equivalent of the 'Format Cells' / 'Fill' / 'Fill Effects' / '2 color Gradient' feature) so that the background cell color (color 2) is set to 'green' with color 1 being set to 'white' with a shading style of "From Center"
I've searched for pointers on how to do this without success - is it even possible to do what I'm trying to achieve?
Any hints / tips / answers much appreciated
(If it helps at all I'm using Excel 2010 but any solution would need to be backward compatible with Excel 2007.)
Thx
shawthingz
Here's a problem I'd like to be able to solve in VBA:
Retrieve the current cell color (let's say A1 = 'green')
Format A1's cell colors (using the VBA equivalent of the 'Format Cells' / 'Fill' / 'Fill Effects' / '2 color Gradient' feature) so that the background cell color (color 2) is set to 'green' with color 1 being set to 'white' with a shading style of "From Center"
I've searched for pointers on how to do this without success - is it even possible to do what I'm trying to achieve?
Any hints / tips / answers much appreciated
(If it helps at all I'm using Excel 2010 but any solution would need to be backward compatible with Excel 2007.)
Thx
shawthingz