Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Change format of cells
I have a spreedsheet where the entries can only be Y, N, NA, N/A. or left blank and the numbers of each are totalled. Even though the sheet is clearly marked what entries can be used, some users of the sheet sometimes enter space Y, instead of Y, or N space A, instead of NA, zeroes etc. There are other various errors which result in incorrect totals being shown. How can I get a cell to show an error, if the cell entry is not one of y, n, na, n/a or left blank. This would indicate to the user that they have made an error? and then have to enter again. I tried conditional formatting but there are only 3 choices, I am confused. Can this be done? Any help greatfuly appreciated. Regards Bill -- williamaleng@ti ------------------------------------------------------------------------ williamaleng@ti's Profile: http://www.excelforum.com/member.php...o&userid=16449 View this thread: http://www.excelforum.com/showthread...hreadid=278089 |
#2
|
|||
|
|||
use <data(menu)-validation
in some range of cells e.g. F1 to F4 type y,n,na,n/a highlight the cells where the user has to enter the value e.g. A1 to A10 click data-validation in data validation window choose <settings in the line <allow (cick the arrow) and choose <list source---click the reference in the right extreme right in this line and highlight F1 to F4 and hit enter key. now in the same data validation window choose <error alert style <stop errormessage type some message e.g. "you have typed wrong" finally click ok now if you select A1 , there will be a small arrow on the right. he can choose from the for lpossibilites If he himself type wrongly it will stop and give an alert message. same will happen if you click A2 etc upto A10 experiment with this. in this waht you want williamaleng@ti wrote in message ... I have a spreedsheet where the entries can only be Y, N, NA, N/A. or left blank and the numbers of each are totalled. Even though the sheet is clearly marked what entries can be used, some users of the sheet sometimes enter space Y, instead of Y, or N space A, instead of NA, zeroes etc. There are other various errors which result in incorrect totals being shown. How can I get a cell to show an error, if the cell entry is not one of y, n, na, n/a or left blank. This would indicate to the user that they have made an error? and then have to enter again. I tried conditional formatting but there are only 3 choices, I am confused. Can this be done? Any help greatfuly appreciated. Regards Bill -- williamaleng@ti ------------------------------------------------------------------------ williamaleng@ti's Profile: http://www.excelforum.com/member.php...o&userid=16449 View this thread: http://www.excelforum.com/showthread...hreadid=278089 |
#3
|
|||
|
|||
Hi
as posted in your original thread: Use Data - Validation. See: http://www.contextures.com/xlDataVal01.html -- Regards Frank Kabel Frankfurt, Germany williamaleng@ti wrote: I have a spreedsheet where the entries can only be Y, N, NA, N/A. or left blank and the numbers of each are totalled. Even though the sheet is clearly marked what entries can be used, some users of the sheet sometimes enter space Y, instead of Y, or N space A, instead of NA, zeroes etc. There are other various errors which result in incorrect totals being shown. How can I get a cell to show an error, if the cell entry is not one of y, n, na, n/a or left blank. This would indicate to the user that they have made an error? and then have to enter again. I tried conditional formatting but there are only 3 choices, I am confused. Can this be done? Any help greatfuly appreciated. Regards Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change Excel format to pdf format? | Excel Discussion (Misc queries) | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
How do i change numbers in text format to number format? | New Users to Excel | |||
Protected cells -automatically format to a different color | Excel Discussion (Misc queries) | |||
change bahttext format to different format style | Excel Worksheet Functions |