Free Microsoft Excel 2013 Quick Reference

- Split cell diagonally
- Is this possible (To split cell diagonally)
- How can I split a single cell diagonally in Excel 2000
- Diagonal cell split
- Splitting A Cell Diagonally
- Can I split a cell diagonally, with text in each triangle ?
- Insert 2 colours in a single cell,corner to corner
- Creating cells with Diagonal borders
- How do I split a cell diagonally?
- Different colour each side of diagonal border
- How to enter in A1 name for row and for column w/diagonal split?
- Creating cells with Diagonal borders
- Diagonal Cell Splits
- How to diag. split a cell for two headings (for row AND column)?
- Can you apply split colour formatting to the same cell?
- Enter 2 values in opposite corners of a cell
- MS Excel Cells
- Can you make a cell with a diagonal, so that you can edit the upper and lowe
- Hello!
- CountIf separately based on backround color?

******** ******************** ************************************************************************>Microsoft Excel - Book1___Running: 11.0 : OS = Windows XP (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutD3=

DEFG3Â Â Â Â 4Â 250Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 125Â 5Â Â 6Â Â Â Â Sheet1Â

[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box

PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

okies wont show the borders of cell on html maker sorry

Kind regards

Nick

to have it contain 2 pieces of information?

Is there a way to split a cell diagonally ? I would like to have 2 data points in a cell that have a diagonal split so it looks like that are still in the same cell with just a diagonal line between them. I also need to be able to still sum the 2 data points.

Thanks

diagnolly, colour each section and be able to type text in each triangle.

Is this possible and if so how ?

Many thanks

Helen

I believe the only way this could be achieved is using a drawing

object(s) i.e. triangle. You could colour the cell and then superimpose a

triangle over the cell (or use two triangles).

For a single cell this might be an option but for multiple cells it's not

(obviously) very practical.

"Andyfishing" wrote:

> I need to colour a cell that is split diagonally with 2 seperate colours?

> Excell 2003.

is the column B & C and rows 2, 3 & 4 use the same vertical & horizontal

height & width

Column A

"Blank"

Shop A

Shop B

Shop C

Column B

Conversion

10%

12%

8%

Column C

Sales $

$1000

%1300

$10000

in each half. Is there a ay of doing this? Currently I create an image of the

cell, edit it in paint and insert.

identified as well as the column name in this same cell A1, separated by a

diagonal. I can draw the diagonal, but how do you get the row name to appear

in the upper right of the cell and the column name to appear in the lower

left?

--

SgtBob

is the column B & C and rows 2, 3 & 4 use the same vertical & horizontal

height & width

Column A

"Blank"

Shop A

Shop B

Shop C

Column B

Conversion

10%

12%

8%

Column C

Sales $

$1000

%1300

$10000

Is this possible? If so, how do I do it?

If not, what other options do I have besides the obvious merge of the row header? I feel the horizontal lines will not separate the large amount of $-data on the sheet...

Looking forward to your responses. Thank you in advance.

Nicholas N.

one for the row heading and the other for the column heading?

diagonally from right to left (one colour being orange, the other being

white/uncoloured). I don't want stripes, just two blocks of colour making up

the cell background.

Slightly bizarre question, I know, but it's for a work diary for a

department with colour representing 'busy' and white/uncoloured representing

'available'. As I'm busy for the first half of the day, I want to split the

cell in half. At the moment I just have a diagonal line and the whole cell in

orange, but wanted to make the 'pm' half of the cell to be clear. If that

makes sense!

Thanks for your help!

Gareth

look right for printing, but I was wondering if there is anyway to

make it so that you can edit.

For example:

I would like to make a cell and then split it into 2 cells, so that it

will almost look like a fraction.

1/2 #1 in the upper cell,# 2 in the lower cell, then use a border

to do the diagonal.

gwillis

Is there any quick way to split a cell diagonally (i.e have item number/item reference in the same cell but splt diagonally by a line).

Thanks,

Stevie

My question is, I want to sum wins (from the row of the table) in the AM column. Each cell that is yellow will have a "W" or "L" in it. Each cell that is red will have a "W", "L", or "S" in it. Is there a way of using a formula to countif the cells equal "W" to and if the cell is red to count W's as 2 and S's as 1? (Red cells represent 2 games each). I'd basically want something similar to:

Except modified to take into account the backround color. I'm not sure if this is possible, so if there's another way, I'd love to hear it.

A second question (should it go in it's own thread?) Is there a formula that I can type into all of the cells below the diagonal line to see if a cell mirrored across from it is a "W" to put an "L" or vice versa? (For instance, if H4 = "W", then D8 = "L"). I know I could manually put formulas into each cell, but that would take a while and was wondering if the experts on here could help.