+ Reply to Thread
Results 1 to 2 of 2

Notification when a value exceeds a limit

  1. #1
    Registered User
    Join Date
    09-11-2012
    Location
    Copenhagen, Denmark
    MS-Off Ver
    Excel Mac 2011
    Posts
    5

    Notification when a value exceeds a limit

    Hi,

    Is it possible to create some kind of a pop-up notification etc. if a value in the spreadsheet exceeds a limit?

    For example:

    Cell A1 contains the formula SUM(B1:B5)
    Cell A2 contains the value 100.

    If A1 exceeds A2 you get a notification that this has occured. I'm not talking about conditional formatting, but something that hits you right in the face when you're working on a big sheet and you can't necessarily keep a close eye on A1 all the time...

    Anyone?

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Notification when a value exceeds a limit

    Never work with Excel in Mac before, but in windows, you can use VBA. The code looks like

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1