Notify if the date expires in Excel DB

[eXtremer]

Hi all.

There is a excel database with columns, there is a column with dates and I need to be notified by excel somehow that it past for example 30 days from that date, is it possible to implement such a thing in excel ? I need to be notified just once, after that to click on it and the reminder has to be set OFF.

I really need to find a workaround.

Thank you in advance.

 

[eXtremer]

Thank, I think I will not use this option, too bad there is no VB code for this.

 

[Ruddles]

There's no reason why it shouldn't work but as with most things, you have to get it right or it won't work.

Try to get it working for a single cell first.

 

[eXtremer]

There's no reason why it shouldn't work but as with most things, you have to get it right or it won't work.

Try to get it working for a single cell first.

So, I need the cells to get red on the DATE_COL column when the expiry date hits.

In my case the DATE_COL is 14...

"=AND(A1>TODAY(),A1<(TODAY()+10))" - The formula you typed contains an error.


Just googled for information about color function in VB and I see there is a way to do, too bad I don't understand the codes...

Link1
Link2

 

[Ruddles]

If your date is in A14 then the formula would have to test A14 rather than A1.

That formula worked fine here:-

 

[eXtremer]

Screenshot

 

[Ruddles]

If your date is in A14 then the formula would have to test A14 rather than A1.

Of course I meant to write: "If your date is in N1 then the formula would have to test N1 rather than A1".

I'm at work at the moment and that image is blocked by the company firewall. I shall look at it tonight when I get home.

 

[eXtremer]

Sorry, what is blocked by the firewall ? The image extention *.jpg, *.gif, *.bnp ? Or what, let me understand so I would make it easier for you to see the screen.

 

[Ruddles]

Sorry, what is blocked by the firewall ? The image extention *.jpg, *.gif, *.bnp ?

It's probably the site: http://extremer.isgreat.org/. File-sharing sites are blocked by many organisations' firewalls.

I just got home and tried the link you posted and I got a picture of two young ladies wearing skimpy swimsuits. I couldn't work out how they related to conditional formatting.

 

[eXtremer]

Sorry, it's a free hosting and sometimes it fails, try to refresh please a few times.
I've uploaded to a image hosting website too...

 

[Ruddles]

Weird! They look the same - apart from the fact that I used A1 and you used A14.

Does that formula work if you put it in a worksheet cell?