Custom Data Validation

[Big Rick]

Hi. Folks.

Please can you good folks help me with some custom data validation.

1. I want to be able to enter the numbers 0 to 21 or the letter R in a cell.
2. I want to be able to enter any whole number or the letter R in a cell.

Your help is and always has been very much appreciated.
Looking forward to your answer in anticipation.
Big Rick.

[JBeaucaire]

1) Assuming the DV cell is C3, use this Custom DV formula:

=IF(ISNUMBER(C3), AND(C3>=0, C3<=21, MOD(C3,1)=0), C3="R")


2) Assuming the DV cell is C3, use this Custom DV formula:

=IF(ISNUMBER(C3), MOD(C3,1)=0, C3="R")

[Big Rick]

Hi. Jerry,

That is truly superb.

I was beginning to think that this was not possible because I normally get help within a few minutes, while this took many hours.
Was this straightforward, or did you have to put on your thinking cap.

Many many thanks.
Couldn't have done it without you.
Best regards,
Big Rick

[JBeaucaire]

It was straightforward. I'd suggest hours for a response is normal for a Sunday.