#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Shading Split Cells

I am working on a spread sheet and have split a cell into 2 halves
diagonally. I would like to color just one part of the split cell. Can I do
that?
If so, in great detail, how?

Thanks so much for considering my question!!!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,696
Default Shading Split Cells

Sounds like the cell just has a diagonal border on it. If so, unfortunately,
the answer is no.
You can, however, insert a drawing ubject using triangle, give the triangle
the color you want and fit it where you'd like it...

"Rebecca T" wrote:

I am working on a spread sheet and have split a cell into 2 halves
diagonally. I would like to color just one part of the split cell. Can I do
that?
If so, in great detail, how?

Thanks so much for considering my question!!!

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Shading Split Cells

Rebecca

You have not "split" the cell, just placed a diagonal border through the middle.

You cannot split a cell and you cannot have two background colors in a cell.


Gord Dibben MS Excel MVP

On Wed, 21 Feb 2007 09:04:55 -0800, Rebecca T <Rebecca
wrote:

I am working on a spread sheet and have split a cell into 2 halves
diagonally. I would like to color just one part of the split cell. Can I do
that?
If so, in great detail, how?

Thanks so much for considering my question!!!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Shading Cells Crazydad42 Excel Discussion (Misc queries) 1 November 10th 06 02:44 AM
shading used cells only mrharpo2u Excel Discussion (Misc queries) 4 June 26th 06 10:36 PM
Conditional Cell Shading (based on the shading of other cells) Tubby Excel Worksheet Functions 2 June 20th 06 11:03 PM
Shading Cells Charlie Birkett Excel Discussion (Misc queries) 1 January 6th 06 01:12 PM
Shading Cells Jeff Excel Worksheet Functions 1 May 4th 05 12:18 AM


All times are GMT +1. The time now is 07:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"