Notice in Excel of a reached set point setting.

R

Rick

Is this task possible to perform in Excel 2003?

I would like to have a quanity of material set point (example. 50) where I
can deduct from this number daily for items used. When the deducted number
reaches a set point of a lower number (example. 25) in the cell, Excel will
notify me by either a flashing cell, color flash/change or astrick flash or
some type of notification.

My plans are to have a Description of the material starting in Column "B",
Cost of item in Column "C", On hand quanity in Column "D", Additional
information in Column in Column "E" and the daily deduction entered in Column
"A". When the line item in Column "A" cell would reach a selected number,
there would be a notification to me of time to reorder the item.

Thank you for your help.
 
S

Shane Devenshire

Excel does not support flashing text, however, you can have the cell change
color by using conditional formatting on the Format menu.
 
R

Rick

Hello Shane,

I see the conditional formating tab in Excel but I am not sure how to set up
the formula correctly. Looks like for my planned use it may be something like
this:
(Condition 1), Cell value is, less than or equal to A1:=A1-D1 Not sure
????
(Where the formula is A1=25-50)

I need the predetermined set value of 25 to turn "red" when a quanity is
entered each day for the material item being used.

Can you help me by providing the formula which I would need to use?

Thanks,
Rick
 
M

Max

I need the predetermined set value of 25 to turn "red" when a quantity is
entered each day for the material item being used.
Click to expand...

Try these steps
Select say, A2:A10 (A2 active),
then apply CF using Formula Is:
=AND($D2<>"",$D2-$A2<=25)
Format to taste > ok out
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

prevent a cell from having data add with out another celled filled 3
Using Excel to capture Inventory 1
Selection of drop down list directs auto population of other cell 1
Median of column I if column A numbers match 2
Date calculations in Excel 2
setting a cell length limit 1
Dates in Excel 2007 5
Easy (?) questions for setting up a database 3

Top