Hi,
Here's one way:
say that your due date is in column D, you could put this formula in a
blank column:
=IF(AND(D10,D1<=TODAY()),"Payment Due","")
another way would be to use Conditional
Formatting......Format/Conditional Formatting............just select
the "formula is" option from the drop down meny and this formula:
=D1<=TODAY()
choose your format....say red background and you're done!
Hope this helps!
JG
--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile:
http://www.excelforum.com/member.php...fo&userid=6261
View this thread:
http://www.excelforum.com/showthread...hreadid=493587