I will get an example to demonstrate my problem.
I have worksheet with data in range A1 to A100 and B1 to B100
Lets say it shows the todays date in A1 to A100 and due date for
paying bill in range B1 to B100 for grocery, phone etc.
If the due date is today (ie A1 = B1) then the excel should
show a message. But, I would like to do that without opening the excel
file.
The problem is to check the values in those cells each time
excel loads (preferably by loading an Addin) and then display a
message if the specified criteria is met.
Thanks in advance.