Results 1 to 5 of 5

Stock Control - Alert user to low stock levels.

Threaded View

  1. #1
    Registered User
    Join Date
    05-29-2013
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    5

    Exclamation Stock Control - Alert user to low stock levels.

    I am trying to make a stock control sheet. I need it to change the colours of corresponding cells when the stock gets to a certain level.

    For instance:
    • 100%-50% - High, Green Box
    • 50%-25% - Medium, Yellow Box
    • 25%-0% - Low, Red Box

    Is there a certain formula or tool I need to use? I'm not very good with Excel but decent with maths.

    I have attached the spreadsheet I'm using.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1