Hide cell text with Format Cells
- Select the cells containing the text to be hidden
- In the Format Cells → Number → Custom: enter a semicolon three times: ;;;
Display positive/negative statuses
- Select a range of cells (usually a column)
- Format Cells → Number → Category: Custom → Type:
|
1 |
[Color10]✅" Complet";[Color3]❌" Eronat" |
Emojis can be added by pressing the combination of keys Win + ;
It can be written [Green] instead of [Color10] and[Red] instead of [Color3]
Thus, if the value will be positive, it will be displayed Complet, if it is negative, it will appear Eronat.
Another example can be rendered like this:
|
1 |
[Green][>35]"Admis";[Red]"Respins" |
Display up-down symbol
|
1 |
[Color10][>50]#▲;[Color3]#▼ |
Phone number format
- Format Cells → Number → Category: Custom → Type:
|
1 |
(0###) ### ### |
