I need to create a conditional alarm ( sound or notification box - pop-up message or any )

Dear Friends, Experts ..

i have some experts in Excel formulas and function, i always use excel to automate my work, but i'm new in the VBA, i know a little pit but please don't depend on with the reply, give me the solution from A-Z ( even tell me how and where to put the code exactly )

I just want to make an alarm conditionally for some cells value ( >, <, = ) i want to have a message box notification or some sound alarm or flashing cells whenever i open the excel sheet, please advise me it is urgent to me to finalize the project i'm working on,

Thanks a lot in advance experts ..

Thanks for the fast response Solus,

Actually i tried to copy your code and i put in the developer ( workbook ) and tried to put values in A&B but no beep or notification done, anyhow maybe i couldn't put it in the right place, i would like to attach the file for you,

Now i did attach it, the meant cells to notification are the ( Y ) i want to make a notification if Y<3 ( if the shipment arrival after three days )

It will be appreciated if i get the general rule so i can do it on many cells in this schedule as it is very important to my work procedure.

Thanks in advance

Dear Solus,

I would like to thank you again for your great effort, we are so close to solve it as i felt,

Now look my friend, the notification box idea is good but some issues should be added to get the requested result,

I may get more than one arrival date and in his case i should have a notification with all of them, and i need to know which of them is the meant one so i should got the container number ( B ) and the message ( about arriving ) then this message box should have many lines to fit to all possible arrivals, and the notification should start automatically to get the benefit of it. this is option 1 - if possible.

Option 2 : if i got just a flashing cells i can set conditionally ( >, <, = )

Thanks a lot in advance and your efforts are absolutely appreciated,

Essam

Very nice and appreciated dear,

I don't know if i'm bothering you or requesting too much, as you got my point and as i saw the idea you made, i read in some place that we can make flashing cells somehow, now i need something similar to this flashing idea or the same that can give each cell its privacy, the message box will not give the exact purpose i'm looking for cause it just appear with a list which i can't use to go in details of the line which is very important to complete the job,

simply my friend, if you have any solution for me to get notified with the whole line and/or just the remain days cell in the line whenever the goods will arrive within 3 days and to keep notified till i change the value of the cell ( W ) to ( under clearance Or Received ).

Really i appreciate your efforts and i would like to tell everybody how useful was this site, and also such as those website will not be powerful without such as your expert and cooperation.

Thanks in advance and i wish i could do something useful for you as well.

Dear Friend,

As you know now what is the result i need, do you have as an expert any solution to get this result, you can suggest me any way you find well.

And thanks in advance .