how to apply one gradient fill to group of cells?

[Harry Geda]

Hello,
I like to add one gradient fill to a group of cells.
I have an area of cells that are 8x14 cells.
I used conditional formatting and created conditions for solid colors.
This looks good but I need to make it with gradient fill.

After choosing a two-color design it paints the individual cells instead of
creating one gradient fill for the groupped area of cells.

How can I do the conditional formatting with Gradient fill to cover the highligted cells as one gradient fill.

Please help,
Harry

 

[Harry Geda]

Phill,

This is very good.
With a little tweak on the text size and using bold
letters i can accomplish this.

Thank you for your work.

Regards,
Harry

 

[pbornemeier]

You're welcome - it's fun when I learn new stuff while working on a problem. I still don't have a complete handle on the changes XL2007 made, especially with the lessening of effectiveness of the macro recorder (wrt graphics) and the dumbing down of the help files!