Can I color one cell two colors?
 

My IT director has asked me how to duplicate something someone else sent in a
document: a table in excel with the top left-hand cell divided diagonally.
I've gotten that far with borders. The trick is, it's also two colors: one
above the diagonal and one below.

I can't seem to find any information on how to manage the color part.

Can I color one cell two colors?
 

The only way I know how to do that is to add a couple of shapes (triangles???)
that divide the cell. Then color each shape the way you want.



Gabrielle wrote:

My IT director has asked me how to duplicate something someone else sent in a
document: a table in excel with the top left-hand cell divided diagonally.
I've gotten that far with borders. The trick is, it's also two colors: one
above the diagonal and one below.

I can't seem to find any information on how to manage the color part.

--

Dave Peterson

Can I color one cell two colors?
 

That worked. I put a triangle up there, colored it, and added a text box.
As long as the cell's text is aligned right it shows through. Director is
satisfied. I can go home for the weekend.

Thanks.

--Gabrielle

"Dave Peterson" wrote:

The only way I know how to do that is to add a couple of shapes (triangles???)
that divide the cell. Then color each shape the way you want.



Gabrielle wrote:

My IT director has asked me how to duplicate something someone else sent in a
document: a table in excel with the top left-hand cell divided diagonally.
I've gotten that far with borders. The trick is, it's also two colors: one
above the diagonal and one below.

I can't seem to find any information on how to manage the color part.

--

Dave Peterson

Can I color one cell two colors?
 

Ah, take the rest of the year off!

Glad it worked ok for you.

Gabrielle wrote:

That worked. I put a triangle up there, colored it, and added a text box.
As long as the cell's text is aligned right it shows through. Director is
satisfied. I can go home for the weekend.

Thanks.

--Gabrielle

"Dave Peterson" wrote:

The only way I know how to do that is to add a couple of shapes (triangles???)
that divide the cell. Then color each shape the way you want.



Gabrielle wrote:

My IT director has asked me how to duplicate something someone else sent in a
document: a table in excel with the top left-hand cell divided diagonally.
I've gotten that far with borders. The trick is, it's also two colors: one
above the diagonal and one below.

I can't seem to find any information on how to manage the color part.

--

Dave Peterson


--

Dave Peterson

Can I color one cell two colors?
 

how do i add a triangle?

"Gabrielle" wrote:

My IT director has asked me how to duplicate something someone else sent in a
document: a table in excel with the top left-hand cell divided diagonally.
I've gotten that far with borders. The trick is, it's also two colors: one
above the diagonal and one below.

I can't seem to find any information on how to manage the color part.

Can I color one cell two colors?
 

ViewToolbars. Open the Drawing Toolbar then AutoshapesBasic Shapes.

Select the triangle tool and you are away.


Gord Dibben MS Excel MVP

On Sun, 31 Dec 2006 09:16:01 -0800, t620002
wrote:

how do i add a triangle?

"Gabrielle" wrote:

My IT director has asked me how to duplicate something someone else sent in a
document: a table in excel with the top left-hand cell divided diagonally.
I've gotten that far with borders. The trick is, it's also two colors: one
above the diagonal and one below.

I can't seem to find any information on how to manage the color part.