custom data validation

A user enters: 1) The Start date of the month in Cell B1 2) The joining date (in case of a new employee) in Cell B2 3) Number of days worked in the current month in Cell B3 which has a custom data validation check as follows...

Hi, I am trying to create a custom data validation and I need some help with the formula syntax. In my spreadsheet Column B has a drop down that says "Refund" and "Charge". I want to create the custom data validation in Column D to limit the number of characters in the cell so that any line...

Hello, I need to validate a column of phone numbers in excel. The fact that phone numbers in Australia start with zero and also I need the final format to be (eg. (02) 4943-2891), is causing me problems :(. I found the following videos on YouTube: https://www.youtube.com/watch?v=7mrc6cEY8oA...

Hi I have cells A7 to A37 and cells B7 to B37 which I would like to only have dates put in those cells in the format dd/mm/yyyy, everything else I would like to be restricted. I have formatted those cells but this has not restricted any date formatting etc. Can this be done via custom data...

Hi everyone! I am currently working on a spreadsheet and I am facing some difficulties in regards to custom data validation. Basically i have a column which contains consecutive numbers, i.e. cell G9 contains 126, G10= 127, G11= 128, G12= 129....etc... so what i would like to do is.. when...

Cell C19 and cell E19 represent "yes" and "no" respectively. I want users to answer the yes or no question by entering an "x" in either C19 (for "yes") or E19 (for "no"). According to my understanding of custom data validation, this formula for C19 below should work. But it continues to allow...

I have created a data validation list so users can select from the drop down option; however I would also like for them to have the ability to type in the cell whatever they'd like (e.g. Not be forced to select a drop down entry). Is this possible, if so, how? i am using excel 2010...thank you...