conditionals notification
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Conditionals notification

Conditionals notification

resolvedResolved · High Priority · Version 2003

replyReply Tue 15 Apr 2008, 16:29Delegate Lara said...

Lara has attended:
Excel Intermediate course

Conditionals notification

Can I set up an automatic notification email to myself should a general acces/input spreadsheet reaches a certain value? eg if an invoice spreadsheet someone else is using shows/reaches a certain value/amount of money overdue/outstanding.

If yes, How?

For upcoming training course dates see: Pricing & availability

replyReply Fri 25 Apr 2008, 16:36Trainer Amanda said...

RE: conditionals notification

Hi Lara

Thank you for your question, and welcome to the forum.

This could only be done by writing VBA code to do this - there is not a standard Excel feature that you could use to do this.

Amanda

 

Please browse our web site to find out more about
excel+training+best and other Microsoft training courses.

Excel tip:

Selecting blank cells within a range of data

Select the range of data which includes the blank cells that you would like to select. Press the F5 key, this will take you to the GoTo dialogue box where you can click on Special and then select Blanks.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard