Data Validation Problem

[Shayooluwah]

I'm trying to create a form, but I'm facing some challenges.
Registration Number should start with an R and have max of 13 characters e.g R1234567891234. I was able to use custom data validation =EXACT(LEFT(D5,2), "R-")
to enforce it starting with R but not for character length.

Then I want some cells(J2:M2) to be un-fillable until others(E2:H2) have text in them. But the problem is that (J2:M2) & (E2:H2) already have this formula/variations of this formula =IF(ISBLANK($I2),"",IF(TODAY()>$I$2+183,"Exam due","")) in them

I tried using this =IF(OR(ISBLANK(L2),ISBLANK(F2),ISBLANK(G3),ISBLANK(H4)),"NEY",IF(ISBLANK($I2),"",IF(TODAY()>$I$2+183,"Exam due","")))

But it doesn't work cause (J2:M2) & (E2:H2) have data validations in them that allows the cells to accept only whole numbers.

So how can I retain the numeric data validation for (J2:M2) & (E2:H2) and still have it to be un-fillable if previous cells are still blank?

 

[Yongle]

Registration Number should start with an R and have max of 13 characters e.g R1234567891234. I was able to use custom data validation =EXACT(LEFT(D5,2), "R-")
to enforce it starting with R but not for character length.

How about
=AND(LEN(D5)<=13,LEFT(D5,1)="R",ISNUMBER(VALUE(RIGHT(D5,LEN(D5)-1))))

 

[Yongle]

Why did you post the image?
- it tells us nothing useful
Your post refers to various ranges
- but you have hidden all row numbers and column numbers in the image

 

[Shayooluwah]

Why did you post the image?
- it tells us nothing useful
Your post refers to various ranges
- but you have hidden all row numbers and column numbers in the image

Sorry that was not intentional, picture got cropped and I did not notice.