View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
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