How to use datavalidation in excel when the cell or particular range is calculated with the formulas. i think that data validation will happen only when any value is entered in particular cell but i need the error message when ever the value changes.
for eg,
A1 contains 0
B1 contains 1
c1 is calulated with the formula =A1+B1
when ever the value is change in A1 or B1 the C1 will be automatically changed the cursor may not go to the particular cell.I need the error as "This less than zero".
Instead of validation use conditional formating (under format menu). If c1<1 format cell as red. It does not have the attention getter that validation does not require the active cell event. Every other option requires the cell become active for a test.
Posted on Apr 13, 2008
Hi,
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Good luck!
Posted on Jan 02, 2017
Jan 19, 2016 | Computers & Internet
on Feb 11, 2011 | Computers & Internet
Nov 20, 2013 | Microsoft Excel 2010
Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.
Formulas used in Excel must follow a certain syntax.
Aug 19, 2011 | Microsoft EXCEL 2004 for Mac
Jan 19, 2009 | Microsoft Office Excel 2003 for PC
Dec 19, 2008 | Microsoft Excel for PC
Jul 29, 2008 | Microsoft Excel for PC
Jun 01, 2008 | Microsoft Excel for PC
May 22, 2008 | Excel (SS8SATAS5128400R)
Dear Madiha35,
I would recommend the use of the Table Function in Excel.
Here are the steps in Excel 2007, if this does not work for your version please add comment for me to reply to.
Conversely, If you would like the softcopy of the screenshots, I would be happy to email them to you.
Step 1: Enter your data into the worksheet.
Step 2: Create Table
Highlight the relevant data
On the insert tab, click on Table
Step 3: Verify Table range is correct, Click OK
Step 4: Select the cell you where you wish to Sum Data.
Click on Autosum.
Step 5: To Insert new data
Click on the sum row in the table, (Not the entire worksheet row)
Right click, Insert, Insert Table rows from above
Step 6: Enter new data in row
Step 7: Data is automatically calculated in formula.
Oct 22, 2007 | Computers & Internet
Mar 21, 2018 | Computers & Internet
163 people viewed this question
Usually answered in minutes!
that was not helpfull bcos when any person working with the bulk datas they will see the change of colour in a particular cell if there is some alret message then it will be usefull. since i know this solution which was failed with my workers so i need the correct solution.
×