Using a custom format to show manual budget items

Show & Tell
#1

I’m new to Tiller, and I was finding it hard to see which items I had overridden for my budget on my categories sheet. I’ve got a bunch of categories and do have some budget items that arrive during specific months.

I’m really liking Tiller, because it is a sheet, I can simply update to solve my issues.

To make my changes visible, I just added a simple Conditional Format rule that checks if the cell is a function, and applies a different cell color if it is:

Screen Shot 2020-11-10 at 1.44.17 PM
Screen Shot 2020-11-10 at 1.44.17 PM322×568 17.2 KB

Now I can see what is automatic, and what is manual.

Screen Shot 2020-11-10 at 1.43.28 PM
Screen Shot 2020-11-10 at 1.43.28 PM841×271 20.5 KB

I see the show & tell so far has been showing some sophisticated solutions. Are there other simple modifications people have made? (Is this the place to show them?) I would love to see more…

Custom Formatting For Your Sheets
#2

This is a great and elegant solution to a common problem, @mre.
Thanks for sharing.

#3

Very nice solution, @mre! Thanks for adding to the community. :slight_smile: I’ll have to keep that conditional formatting in my back pocket for when I’m modifying or troubleshooting my sheets.

#4

So cool! I love reading about the sophisticated solutions - I don’t have enough spreadsheet smarts to implement, but I love reading about them. BUT this! This I can do. Thanks for the idea!

#5

Hi @mre. Welcome. I agree, too: this is a great way to see at a glance the character of the data. Great work, and thanks for sharing it!

#6

Nice job, I love conditional formatting.

My simple (similar) modification is that I use conditional formatting on the Transactions sheet Category column to highlight any transactions that are not categorized. It’s a minor change, but makes it easier to see if I skipped categorizing something.

2 Likes
#7

This is exactly the kind of thing we’d also hoped for with Show & Tell so absolutely the right place to show them.

Sophisticated solutions are great, but simple things that make your money easier to understand are welcome and encouraged here too!

1 Like
#8

Elegant! Can’t wait to try this in my budget.

#9

I love this!
Does anyone have ideas on how something similar could be implemented on the Budgets History sheet instead?