Hi,
The title may be a little misleading, that is just my current train of thought.
I'm trying to develop a spreadsheet that helps track inventory for a friend's property business.
So we have a tab called Current Inventory that looks like this:
Pots Pans Mugs Knives Forks 123 Street 4 Bed Lux 1 2 3 4 5 10 Great Street 3 Bed Lux 2 3 4 5 6 1 Burton Place 1 Bed Apt 1 3 4 5 6 22 Jump St 2 Bed Apt 4 3 2 1 5 100 Another St 3 Bed Apt 1 2 3 4 5 25 Main St 3 Bed Apt 25 2 3 4 5
And another tab called Starting Inventory that is very similar but with different numbers
Pots Pans Mugs Knives Forks 4 Bed Lux 10 4 10 20 20 3 Bed Lux 10 4 7 10 10 1 Bed Apt 4 1 5 10 10 2 Bed Apt 4 2 5 10 10 3 Bed Apt 4 2 5 10 10
We'd like conditional formatting on the current inventory tab that shows if the current inventory is higher, lower or exactly the same as the starting inventory for a house of it’s type.
So for example, we’d would want to check 25 Main St against the inventory for a 3 Bed Apt and would like it to show Blue for mugs (there are too many), Green for pans (there are the right amount of pans) and Red for the rest, as items have been lost.
Because we’re comparing it to a property of a certain type we can’t just use generic rules and IF statements in the rules quickly got messy as there are a lot of property types.
I feel like it should be simple but I just can’t work it out and I’ve been looking at it for so long I think I’m missing the bigger picture.So I thought I'd ask and see if anyone had any ideas.
If anyone knows how to do this or can point me in the right direction, I'd be hugely grateful.
Bookmarks