Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
splitting a celll into half or quadrants
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
splitting a celll into half or quadrants
You can manually select text parts to format different colors.
Background color......no. Gord Dibben MS Excel MVP On Tue, 18 Mar 2008 08:12:01 -0700, cardosol wrote: 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
splitting a celll into half or quadrants
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 On Tue, 18 Mar 2008 12:29:42 -0700, Gord Dibben <gorddibbATshawDOTca wrote: You can manually select text parts to format different colors. Background color......no. Gord Dibben MS Excel MVP On Tue, 18 Mar 2008 08:12:01 -0700, cardosol wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
print half of rows on left and other half on right | Excel Discussion (Misc queries) | |||
Chart with Quadrants | Charts and Charting in Excel | |||
Celll Address Lookup | Excel Worksheet Functions | |||
Function Pitfalls in Celll Formatting | Excel Discussion (Misc queries) | |||
checking celll in column | New Users to Excel |