validation in a cell

  1. G

    Validation of data's of Sheet 1 in sheet 2 of the same workbook

    In a workbook I have two sheet "Sheet 1" and "sheet 2". On *sheet 1" is the data I got from a website, The table is header Starts from A2:C23 ID DATE TIME 430019827 Apr 202410:00:54 AM 430019927 Apr 202410:01:44 AM 430020027 Apr 202410:02:34 AM 430020127 Apr...
  2. D

    Prevent paste from wepage overriding custom validation cell

    I have a small range of cells that have a custom validation that prevents entry when another cell is true. I have users copying from a web page and pasting into these cells and therefore overriding the validation. I've spent hours reading forums and trying various codes, probably in the wrong...
  3. Z

    Two validations in one Cell

    Hi. I'm a new user and i'm finding a solution for this case: I need that in a one cell the user input only can write a string specifically of 7 or 10 characters, the values 1 to 6 and 8, 9, or greater than 10 are not valid, I tried to solve this with validation but i can't, i hope anyone can...
  4. K

    Conditional Validation

    I want to create a list of valid values for use in cell A1. But I only want this validation criteria to apply if A2 = TRUE. If A2 = FALSE, then I want to allow any value in A1. Is this possible? Thank you.
  5. S

    Data Validation witih multiple critieria

    Suppose I want in column A the following requirements. What shall do to get his. Column A xxxx yyyyy xxxxx 11111 these item codes should be accepted if it is not duplicated in the same A column, further it should not accept any other codes that is supposed to be in Column A only. ( A List is...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top