validation help

[ganeshpoojary05]

hi all,

i need a help in validating cells.

for example:

I am preparing a Attendance Report, i need to validate in such a way that if there are leaves(L) more than 10, than it should not allow me to enter and it should prompt a message as "Leaves Exceeded"

 

[Sektor]

Go to Data tab and press Data Validation.
Here you can set your requirement for input data. Also you can display warning in case of incorrect input.

 

[T. Valko]

hi all,

i need a help in validating cells.

for example:

I am preparing a Attendance Report, i need to validate in such a way that if there are leaves(L) more than 10, than it should not allow me to enter and it should prompt a message as "Leaves Exceeded"

Let's assume the range of cells is A2:A20.

Select the entire range A2:A20
Goto Data>Validation
Allow: Custom
Formula: =COUNTIF(A$2:A$20,"L")<=10
Click the Error Alert tab
As the error alert message enter: Leaves Exceeded
OK out