I would like to use conditional formatting to let me know in red if the
number of received items is less than the number of ordered items. I
know I can do this if I have a specific number of items always ordered,
but that number always changes. I also would like a date to turn red if
the schedualed date an item was supposed to come in is past today's
date, any day of the year. Can anyone help?


--
Roz
------------------------------------------------------------------------
Roz's Profile: http://www.excelforum.com/member.php...o&userid=29746
View this thread: http://www.excelforum.com/showthread...hreadid=494594