Minimum and maximum quantities inventory sheet

Hi!

How to set up minimum and maximum quantities on master inventory sheet.

Also, add a column for a name to input for the person checking out items.

Thanks

Hi there!

The minimum and maximum quantities I would solve by using conditional formatting.

As a result, cells would be flagged red whenever quantities entered are more than max and less than min.

And of course, you can add an additional column but make sure to append it at the end to not interfere with the existing column structure.

Thanks Bobby!

I think I understand what I need to do next.