Yesterday we gave an intro to custom formats. Today we show you more of what you can do.
The file is Custom Formats Expanded. Keep this handy for some formats you could cut and paste to use in your workbooks.
With custom formats, you have four sections in the format:
positive number
negative number
zero
text
Each section is separated by a ";".
In the first example in the spreadsheet, we show the following format:
[Green] General;[Red] -General;[Blue] General;[Yellow] General
This can be broken down as:
positive number- [Green] General; - a positive number will be green
negative number- [Red] General; - a negative number will be red
zero- [Blue] General; - zero will be blue
text- [Yellow] General - text will be yellow (note there is no ";" at the end of the text format
You don't need to specify all 4 options.
If you don't care about changing the format for a number and there is no text involved, then you would just specify the positive number format, which would apply to all numbers
If you just care about the positive and negative number format and nothing else, then you could just specify the first two formats.
The file shows other examples:
Working with days and months and years
Combining with text
Using formats to check inputs
Others
Custom formats are a nice way to spruce up your spreadsheets. Another option can be conditional formatting, which we covered before.
Keep this file handy, and cut and paste the examples when you need them for formatting.