splitting a celll into half or quadrants

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cardosol - 18 Mar 2008 16:12 GMT

Hello,

is there a way to divide a cell into half so text or color coding can be
applied to the same cell but not have the colors or text overlap?

Reply to this Message

Gord Dibben - 18 Mar 2008 20:29 GMT

You can manually select text parts to format different colors.

Background color......no.

Gord Dibben MS Excel MVP

>Hello,
>
>is there a way to divide a cell into half so text or color coding can be
>applied to the same cell but not have the colors or text overlap?

Reply to this Message

Minitman - 21 Mar 2008 21:34 GMT

Your right Gord for individual cells ( or merged cells), but there is
a work around.

If your use more then one Excel column for each column of information,
then you can format the text to 'center across selection' and color
each cell in that selection differently with the text going through
the various colored backgrounds.

HTH
-Minitman

>You can manually select text parts to format different colors.
>
[quoted text clipped - 6 lines]
>>is there a way to divide a cell into half so text or color coding can be
>>applied to the same cell but not have the colors or text overlap?

Reply to this Message