Embed payment alert function inside worksheet
 

Hi,

I have one excel 97 worksheet storing bill payment(electricity, mobile
phone, broadband internet account, credit cards, etc) details as
follow example:

Column A Column B Column C Column D Column E
A/C No. Current Payment Date Pay Amount Next Payment Date (Payment
Alert)

Now I used the function =(Bx-TODAY()-1) where x=1,2,3,... embeded in
cells of column E to help me check if any bill is due for payment
(those rows with negative numbers appeared in column E cells because I
set cell format for column E's cells as numeric).

I would like to ask if there is any excel macro or VBA functions that
can help me build auto check functions for column E's cells' content
and pop-up message window whenever it checks negative numbers in
column E's cells ?

Tks!