• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 529
  • Last Modified:

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
0
bowemc
Asked:
bowemc
1 Solution
 
byundtCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now