Solved

Fill cell with gradient of 2 colours - excel 2002

Posted on 2011-09-11
1
491 Views
Last Modified: 2012-05-12
Hi

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

Thanks
0
Comment
Question by:bowemc
1 Comment
 
LVL 81

Accepted Solution

by:
byundt earned 500 total points
ID: 36519670
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

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Excel In-Cell Dropdown is very wide 5 40
modify formula same cell multiple times 15 29
Excel VBA 10 39
Data in Rows to be converted into single row 9 40
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question