I want to know how to :

1. Colour One cell with two colours€¦ the top half in one, and the bottom in
another

Only one background colour can be applied to a cell.

Hope this helps.

Pete

On Dec 8, 8:58*am, Muffi Zainu
wrote:
I want to know how to :

1. Colour One cell with two colours… the top half in one, and the bottom in
another

hi
if you are talking background color. can't be done. sorry.
you can have 2 or more font colors in a cell but text only. not numbers or
fomulas.

Regards
FSt1

"Muffi Zainu" wrote:

I want to know how to :

1. Colour One cell with two colours€¦ the top half in one, and the bottom in
another

With Excel 2007 you could use Format -- Cells -- Fill and use the "Fill
Effects" option to set a cell to use shading with one color for the upper
half and a second color for the bottom half. But there is not a well-defined
border between the 2 colors; one fades into the other.

This feature is not available in Excel 2003 and earlier versions.

"Muffi Zainu" wrote:

I want to know how to :

1. Colour One cell with two colours€¦ the top half in one, and the bottom in
another

If you likeyou can try another workaround by merging adjacent cells.
http://img682.imageshack.us/img682/5067/58225302.png
Micky


"Muffi Zainu" wrote:

I want to know how to :

1. Colour One cell with two colours€¦ the top half in one, and the bottom in
another

Thanks alot JLatham. This really helps. The Shading is a bit annoying,
but atleast I can get my job done!! :)

Thanks again