Thank you Max,
Excellent job, works perfectly as you recommended...

Rick

"Max" wrote:

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

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
---