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.

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

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

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

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.

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.