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

"Shane Devenshire" wrote:

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

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Rick" wrote:

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.