LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 334
Default Notice in Excel of a reached set point setting.

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
setting a formula = to no point in a graph jxbeeman Excel Discussion (Misc queries) 3 October 21st 08 10:04 PM
Disable the Excel Security notice pop-up? Tykenet Excel Discussion (Misc queries) 2 October 9th 08 08:40 PM
Anyone notice excel search within cell limited to first 1024 chars frank479 Excel Discussion (Misc queries) 1 May 14th 06 04:55 AM
setting defaults for data point size, color, shadow, etc. EJF Charts and Charting in Excel 3 March 4th 06 07:07 PM
setting a floating decimel point Rose New Users to Excel 2 April 29th 05 06:10 PM


All times are GMT +1. The time now is 02:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"