Can I in Excel split one cell into 2 halfs and have each half filled wit a
seperate color?

Soren

As explained no, but if you expand what you are trying to do, someone may
have a solution

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk

UK Excel User Conference In Cambridge
November 28th - December 1st 2007
Register Now @ http://www.exceluserconference.com/UKEUC.html


"Soren" wrote in message
...
Can I in Excel split one cell into 2 halfs and have each half filled wit a
seperate color?

You could do it to two adjacent cells (narrow column) to achieve the
effect, but not to a single cell.

Hope this helps.

Pete

On Nov 1, 7:14 pm, Soren wrote:
Can I in Excel split one cell into 2 halfs and have each half filled wit a
seperate color?

Like the Greek atom, cells are indivisible
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Soren" wrote in message
...
Can I in Excel split one cell into 2 halfs and have each half filled wit a
seperate color?

Hi

You can't split a cell.
You could give the appearance of a split cell by using the drawing Toolbar,
selecting the rectangle and creating two identically sized rectangles which
just covered one cell.
Right click on each rectangle and use Format Autoshape to the colour you
wanted for each one.

--
Regards
Roger Govier



"Soren" wrote in message
...
Can I in Excel split one cell into 2 halfs and have each half filled wit a
seperate color?