Fill any five cell only

[kamaruddinjnv]

A. B. C. D. E. F. G
1. 4. 6. 8. 9. 6
2. 6. 8. 9. 4. 3
3. 4. 5. 7. 8. 3
4
5
FILL LIKE THIS.
IF FILL MORE THAN FIVE CELL IT SHOULD SHOW ERROR.

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Try this
Select A1:G5
Data ribbon tab -> Data Validation -> Settings tab -> Allow: Custom -> Formula: =COUNTA($A1:$G1)<=5 -> OK

 

[kamaruddinjnv]

Thanks mr Peter, its working nicely.
but i want to add one more criteria in this cell like in b1:b3 cells not more than B5 value.
how can i add this validation also.

 

[Peter_SSs]

Please review the first paragraph of my previous post.

Thanks mr Peter, its working nicely.

Good news. Thanks for the confirmation.

i want to add one more criteria in this cell like in b1:b3 cells not more than B5 value.
how can i add this validation also.

I am not entirely clear what is required. Can you give some examples of rows of data showing what is allowed and what is not allowed with XL2BB and explain again in relation to that sample data?