Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Can two formats be applied to a cell with a diagonal border

I am creating a calendar that is required to display corporate meetings.
Where multiple meetings fall on one day I would like to format the cell to
show the formats for each meeting. I thought I could use the diagonal
border line in each cell and enter a format in each quarter. is this
possible?

thanx
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default Can two formats be applied to a cell with a diagonal border

If you are entering the details manually, then with care you can use
spaces and line-feeds (ALT-Enter) to position the entries to be either
side of the diagonal lines. You can also highlight part of the text
entry within that cell and set a format (eg colour) for it. It would
involve some trial and error.

If you wanted to do this via a formula or using Conditional Formatting
then you will not be able to.

Hope this helps.

Pete

On May 7, 5:50*am, Deb-Ellen
wrote:
I am creating a calendar that is required to display corporate meetings. *
Where multiple meetings fall on one day I would like to format the cell to
show the formats for each meeting. *I thought I could use the *diagonal
border line in each cell and enter a format in each quarter. *is this
possible?

thanx


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
different colour each side of diagonal border frisby Excel Discussion (Misc queries) 2 June 19th 06 03:55 PM
blank cell until after formula applied junkmandan Excel Discussion (Misc queries) 4 January 26th 06 07:34 PM
Changing the border of one cell s/n change the border of adjacent gjanssenmn Excel Discussion (Misc queries) 2 October 5th 05 08:35 PM
How do I place diagonal lines in a cell in Excel. ezas1040 Excel Discussion (Misc queries) 3 February 25th 05 05:59 AM
Can you make a cell with a diagonal, so that you can edit the upper and lower part of the cell? g wills New Users to Excel 3 February 17th 05 10:23 PM


All times are GMT +1. The time now is 12:58 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"