Colour One cell with two colors

M

Muffi Zainu

I want to know how to :

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

FSt1

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
 
J

JLatham

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.
 
M

MuffiZainu

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

Thanks again
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Question about conditional formatting of zeros in Excel 0
Changing coloue cell en text colour by clicking cell 3
Remove colour change 4
Format Cells - Fill colour Help 11
Excel Conditional Formatting Removal 7
Can you apply split colour formatting to the same cell? 4
Cell formats 2
Excel Remove Excel Background Colours 1

Top