Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Partially fill cells
Is there a way to partially fill a cell with color or pattern. I have tried
clicking "add vertical border" hoping that it would add a border to the center of the cell, but nothing happens. Whether or not it has a border is not relevant, partially filling the cell is the real challenge. Thanks, Neil |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Partially fill cells
The short answer is No. A cell is a cell and can not be split.
The long answer is that there may be a workaround you can use. If you select two adjacent cells On the same row, then format horizontal alignment to Centre across selection, you can then fill one of the cells only with a colour/pattern. I don't know if it helps, but it's the only option I can think of. -- Ian -- "Neil M" wrote in message ... Is there a way to partially fill a cell with color or pattern. I have tried clicking "add vertical border" hoping that it would add a border to the center of the cell, but nothing happens. Whether or not it has a border is not relevant, partially filling the cell is the real challenge. Thanks, Neil |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Partially fill cells
XL 2007 will do this, but not previous versions.
Dave -- Brevity is the soul of wit. "Neil M" wrote: Is there a way to partially fill a cell with color or pattern. I have tried clicking "add vertical border" hoping that it would add a border to the center of the cell, but nothing happens. Whether or not it has a border is not relevant, partially filling the cell is the real challenge. Thanks, Neil |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Partially fill cells
Thanks Dave and Ian! Look like I need to upgrade to 2007. :) or figure out
something else. I can always shrink the cells to haf size, merge the ones that don't need to be partially filled with color or pattern and then only. "Ian" wrote: The short answer is No. A cell is a cell and can not be split. The long answer is that there may be a workaround you can use. If you select two adjacent cells On the same row, then format horizontal alignment to Centre across selection, you can then fill one of the cells only with a colour/pattern. I don't know if it helps, but it's the only option I can think of. -- Ian -- "Neil M" wrote in message ... Is there a way to partially fill a cell with color or pattern. I have tried clicking "add vertical border" hoping that it would add a border to the center of the cell, but nothing happens. Whether or not it has a border is not relevant, partially filling the cell is the real challenge. Thanks, Neil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fill blank cells with cells above data | Excel Worksheet Functions | |||
Is there a way to count cells in a range based on fill color? | Excel Worksheet Functions | |||
auto color fill cells | New Users to Excel | |||
How to fill in "BLANK" Cells Automactically...Large Spread Sheet | Excel Discussion (Misc queries) | |||
blank cells with auto fill in excel | Excel Worksheet Functions |