Results 1 to 2 of 2

Thread: Data Validation Formula

  1. #1

    Data Validation Formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have values in cells A1 & A2 with a forumla in cell A3 that gives the differece of the two (A1-A2). I'm trying to get the data validation tool to pop up a message if the sum in cell A3 falls below 600,000. Can someone please help? It sounds so easy, but I'm missing somthing in my formula! Thanks kindly.

  2. #2
    Hello,

    The Data Validation is used to allow or not a data input in a Cell. It is only used when you type some data in a cell.

    If you want to get a kind of message or an alert (maybe a color change in the cell) you can use Conditional Formatting.

    In the newest versions of Excel you can also use an Icon set that allows you to use some figures to have an alert.

    Another thing that you can do is to put in another cell an IF function. Maybe like that:

    =IF(A3>600000,"Warning!!!","")

    Best Regards,
    Microsoft Excel Massive Open Online Course.
    Learn all about Microsoft excel in this Online course, with video tutorials, examples of applications and a complete functions and buttons explanation.
    Be part of our community and enjoy learning Excel.

Posting Permissions

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