I work in the warehouse environment and I was wondering if there was a way to show a bins fill capacity? The bin holds 500 psc when full and the bin currently has 250 psc in it so the cell shows half full with color or something. 400 the bin shows more full. when capacity is reached the bin shows a full color?
Just wondering
Look at the Conditional Formatting > Data Bars > More Rules.
Minimum > Number > 0
Maximum > Number > 500
Let me know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks