Recently there have been a few community posts offering tips to custom format your sheets and make them easier to read and understand.
I want to share those tips and offer a few new ideas. Feel free to add your own Custom Formatting tips and tricks below.
@mre wrote about how you can use a custom format to show manual budget items:
@Brad.warren described how you can customize your Transaction sheet to confirm receipts and AutoCat choices:
Here are a few more tricks.
Conditional Formatting for you Amount column
Let’s say you want to make your positive amount (usually Income) transactions stand out in your Transactions sheet.
If you Amount Column in your Transactions sheet is Column E, you can set up a Conditional Format rule where you:
- Apply to range: E2:E
- Format Rules: Format cells if Greater than 0
- Formatting Style: Whatever you want. Perhaps fill with a dark green background and white text. Or make it bold.
If you want the entire row with a positive amount to have the conditional formatting (not just the Amount column) then select then:
- Apply to range: A2:E (or instead of E, the last column where you want the formatting)
- Format rules: Format cells if Custom formula is =$E>0 (which E is the Amount Column)
- Formatting Style: Again, whatever you want.
Do you want to colorize your Categories sheet based on the Category Type? You can add a conditional format rule like this to your Categories sheet:
- Apply to range: A2:AK (instead of AK, use the last column of your sheet)
- Format rules: Format cells if Custom formula is =$E2=“Income” (which E is the Type Column)
- Formatting Style: Perhaps make all Income Types green background.
Repeat this rule by changing the word Income for Expense and selecting a different style.
Another approach to formatting numbers is to use the Custom Number Format. You can select different formats for positive, negative, zero, and text results.
@benlcollins has a good tutorial on this on his website:
These are just meant to be some examples of how to use custom formatting in Google Sheets and Tiller. The concepts here can work on any sheet although some Tiller Sheets have existing formatting so you might not want to override that.
Share your tricks below.
Jon