+ Reply to Thread
Results 1 to 7 of 7

how to pop up a message based on a cell value??

  1. #1
    paul
    Guest

    how to pop up a message based on a cell value??

    Hello,

    My Cell C3 is a numeric value.....I have set conditional formatting to
    make the text red and bold when the number is equal or less than 10,000
    is there a way I can make cell E3 display a message when the C3
    condition is true?? or if not a message is there a way to make a
    message box pop up when my C3 condition of less then or equal to 10,000
    is true?

    how would I do something like this?


  2. #2
    Biff
    Guest

    Re: how to pop up a message based on a cell value??

    Hi!

    >make cell E3 display a message when the C3 condition is true??


    Enter this formula in cell E3:

    =IF(AND(ISNUMBER(C3),C3<=10000),"Your message here","")

    Biff

    "paul" <[email protected]> wrote in message
    news:[email protected]...
    > Hello,
    >
    > My Cell C3 is a numeric value.....I have set conditional formatting to
    > make the text red and bold when the number is equal or less than 10,000
    > is there a way I can make cell E3 display a message when the C3
    > condition is true?? or if not a message is there a way to make a
    > message box pop up when my C3 condition of less then or equal to 10,000
    > is true?
    >
    > how would I do something like this?
    >




  3. #3
    paul
    Guest

    Re: how to pop up a message based on a cell value??

    Again thank you!

    Biff wrote:
    > Hi!
    >
    > >make cell E3 display a message when the C3 condition is true??

    >
    > Enter this formula in cell E3:
    >
    > =IF(AND(ISNUMBER(C3),C3<=10000),"Your message here","")
    >
    > Biff



  4. #4
    paul
    Guest

    Re: how to pop up a message based on a cell value??

    hey its not me!
    --
    paul
    [email protected]
    remove nospam for email addy!



    "paul" wrote:

    > Again thank you!
    >
    > Biff wrote:
    > > Hi!
    > >
    > > >make cell E3 display a message when the C3 condition is true??

    > >
    > > Enter this formula in cell E3:
    > >
    > > =IF(AND(ISNUMBER(C3),C3<=10000),"Your message here","")
    > >
    > > Biff

    >
    >


  5. #5
    Biff
    Guest

    Re: how to pop up a message based on a cell value??

    You're welcome!

    Biff

    "paul" <[email protected]> wrote in message
    news:[email protected]...
    > Again thank you!
    >
    > Biff wrote:
    >> Hi!
    >>
    >> >make cell E3 display a message when the C3 condition is true??

    >>
    >> Enter this formula in cell E3:
    >>
    >> =IF(AND(ISNUMBER(C3),C3<=10000),"Your message here","")
    >>
    >> Biff

    >




  6. #6
    Registered User
    Join Date
    02-27-2014
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: how to pop up a message based on a cell value??

    hi all my sheet 1 column d contains several dates & column a contains several names, what I am looking for is whenever I open this workbook if column D date matches with today's date & column A's name pop's up the name which have corresponding to column d's todays date. can someone help me?

  7. #7
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: how to pop up a message based on a cell value??

    Hello and welcome to the forum.

    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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