ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can two formats be applied to a cell with a diagonal border (https://www.excelbanter.com/excel-discussion-misc-queries/186445-can-two-formats-applied-cell-diagonal-border.html)

Deb-Ellen

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

Pete_UK

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




All times are GMT +1. The time now is 12:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com