Hi all,
I am still very much a beginner with excel but I am trying to create a warehouse location tracking spreadsheet to help me manage my warehouse a bit better (which I know is over my head but I like the challenge).
I don't even know if I am going to properly ask this question but here goes.
I have a worksheet that has all the possible pallet locations in my warehouse (much more but you get the point):
I have another sheet that has each location on a row, with it's item and quantity, etc. (we will call this live inventory).
I created a pivot table from the live inventory, because sometimes the locations repeat if there are more than one product in that location. I only need to know there is something in there so I copied the data from the pivot table, leaving the value as "count".
My question is, how can I format the pallet position cells so they will show red if the pivot table shows something there?
Again I am a beginner, but I've tried:
conditional formatting, with a vlookup formula that works but it only works on one cell and if I drag the formula, it changes the whole thing to red.
an if formula with a nested vlookup that went nowhere
should I be using an hlookup? I don't think so, because the pivot table is vertical, am I wrong?
do I even need conditional formatting? Should this be a simple IF formula?
and I'm not sure exactly how to word this properly so I've been having a hard time googling stuff. Lots of conditional formatting videos, but I'm lost and/or overthinking it or completely looking the wrong way.
any guidance would be appreciated.
thank you in advance.
I am still very much a beginner with excel but I am trying to create a warehouse location tracking spreadsheet to help me manage my warehouse a bit better (which I know is over my head but I like the challenge).
I don't even know if I am going to properly ask this question but here goes.
I have a worksheet that has all the possible pallet locations in my warehouse (much more but you get the point):
I have another sheet that has each location on a row, with it's item and quantity, etc. (we will call this live inventory).
I created a pivot table from the live inventory, because sometimes the locations repeat if there are more than one product in that location. I only need to know there is something in there so I copied the data from the pivot table, leaving the value as "count".
My question is, how can I format the pallet position cells so they will show red if the pivot table shows something there?
Again I am a beginner, but I've tried:
conditional formatting, with a vlookup formula that works but it only works on one cell and if I drag the formula, it changes the whole thing to red.
an if formula with a nested vlookup that went nowhere
should I be using an hlookup? I don't think so, because the pivot table is vertical, am I wrong?
do I even need conditional formatting? Should this be a simple IF formula?
and I'm not sure exactly how to word this properly so I've been having a hard time googling stuff. Lots of conditional formatting videos, but I'm lost and/or overthinking it or completely looking the wrong way.
any guidance would be appreciated.
thank you in advance.