Data Validation

[EBoudreau]

I am trying to get some data validation to work based on if a certain value is entered to not allow it and notify user.
I see all the options are to compare to “allowed values” but I would like to prompt user and not allow just the letter C to be entered in some ranges of cells.
How would one go about getting that setup?

 

[MARK858]

Click the first cell in the range (in this case A2) then in Data Validation in the allow section choose custom then in the formula box type

=A2<>"C"

.
Then select the cell, copy, select the rest of the range and Paste Special - Validation

Book2
	A
2	D
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
Sheet1

Cells with Data Validation
Cell	Allow	Criteria
A2:A18	Custom	=A2<>"C"

 

[EBoudreau]

Excellent! I will give that a shot!