Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

conditionals notification

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

Conditionals notification

ResolvedVersion 2003

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?

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

Excel tip:

Applying and removing border from cell in Excel 2010

Did you know the shortcut key for applying and removing the outline border for a cell?

CTRL+SHIFT+& Applies the outline border to the selected cells.
CTRL+SHIFT_ Removes the outline border from the selected cells.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.08 secs.