Windows 10: Formatting Cells

I am trying to split one cell horizontally in a word table, but when I do, all the other cells in the row double in height. How do I add an extra row in one cell without altering the overall height?

Thank you

:)

 

excel cell formating

You dont need conditional formatting (in your simple case)

1./ Highlight the cell you want to format.
2./ Format/Cells... and choose category "custom"
3./ In the Type: box enter: #,##0.00;[Red]-#,##0.00
4./ For percent format use 0.00%;[Red]-0.00%

Done.

 

How To Format A Write Protected Flash Memory ?

¿You already tried this one?...

Run CMD


1. diskpart
2. list disk

Then in the 3º step, put the correct number of disk in the list for the usb flash (if it's listed in disk 3, then you'll have to write select disk 3).

2. select disk #
3. clean
4. create partition primary
5. select partition 1
6. active
7. format fs=fat32
8. assign
9. exit

with that commands you will format the flash drive in fat32, if you have a large drive you can select also "format fs=ntfs" in step 7.

good luck!

 

excel cell formating

What you're looking for is called conditional formatting. Highlight the cells you want, click on the Format header in the top toolbar (it'll be in a different place for Office 2010 but you're looking for the same thing). From there you can enter your condition values and set the formatting to do to the cell what you want when the condition is met. Additionally you can set multiple conditions for the same cells for example red when the value is below zero and black when the value is positive. You can have the whole cell change colors or just the text.