Can two formats be applied to a cell with a diagonal border

D

Deb-Ellen

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
 
P

Pete_UK

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
 

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

Top