Fill cell with gradient of 2 colours - excel 2002

Hi

In excel 2002, is it possible to fill a cell with a gradient of 2 colours?

Thanks
bowemcAsked:
Who is Participating?
 
byundtConnect With a Mentor Commented:
bowemc,
In Excel 2003, you cannot put a gradient fill in a cell. That feature was added with Excel 2007.

You can, however, create a rectangular shape object with a gradient fill and size it to match the cell. You can furthermore have that shape display a value linked to the underlying cell.

To create the fill:
1) Right-click the shape
2) Choose Format the AutoShape from the resulting dialog
3) Go to the Colors and Lines tab
4) Click the Color field and choose Fill Effects... from the resulting dialog
5) Go to the Gradient tab and choose the option for Two colors.
6) Pick your colors and then choose your preferred option for Shading Style.

To create the value:
1) Left-click the shape
2) Click in the formula bar and enter a formula like:
=D6
This formula must be a simple cell reference. It cannot do any logic or calculation--but you can link to a cell that does have complex logic to decide what value to return.
3) You can use the Format...AutoShape...Alignment to center, left or right-align the value

Brad
GradientAutoShapeQ27302325.xls
0
All Courses

From novice to tech pro — start learning today.