Do something like this. If you have your parts quantity in D1, in E1 type in
the quantity when you want to reorder tha part then highlight cell D1. Go to
format then choose conditiona formatting, choose cell value less than e1
then format it the way you want.
