less than or equal to and string in data validation

[ENEMALI]

I want to apply data validation to some cells. The validation rule is the data in those cells must be less than or equal to 10 or this text "ABS"
I tried using = OR(<=10,"ABS") in custom validation but it didnt work.
How do i go about this.
Thanks in advance

[TMS]

You need to provide a cell reference. Custom DV, Formula:

Please Login or Register  to view this content.

You could, for example, select many cells (including cell A1) and apply that formula. The cell reference will auto adjust.


Regards, TMS

[ENEMALI]

It works perfectly. Thanks alot

[TMS]

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.