Why not just use conditional format for cell value over 30?
and then in the cell next to it. just put
=IF(A130, "OVERDUE", "")
--
Bearacade
------------------------------------------------------------------------
Bearacade's Profile:
http://www.excelforum.com/member.php...o&userid=35016
View this thread:
http://www.excelforum.com/showthread...hreadid=550155