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.
it's calling Conditional formating.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
You are a god send!
If it doesn't take up too much of your time, could you tell me how to do it step by step for future reference?
Conditional Formatting>>Manage rules>>New rules>Use formula to determine.
Alright, thank you very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks