Cell locking and data validation

[CMucha]

I am working on a form and need some help. There is a column of cells that has a data validation drop down list,(pass,fail). Based on the “pass” selection in an individual cell the next five cells should be locked. Is it better to use a VBA or custom data validation ? And how would I build it to not interfere with the other drop down list validation ?

 

[6StringJazzer]

When you say "locked" I assume you mean "user may not enter any data."

What is in the other five cells that want to lock? You could put custom data validation in those five cells like

=A1<>"pass"

where A1 is the pass/fail selection

What is the other dropdown list validation that you don't want to interfere with?

 

[CMucha]

When you say "locked" I assume you mean "user may not enter any data."

What is in the other five cells that want to lock? You could put custom data validation in those five cells like

=A1<>"pass"

where A1 is the pass/fail selection

What is the other dropdown list validation that you don't want to interfere with?

It’s a drop down list in column F and I need to lock from GHIKJ

 

[6StringJazzer]

What is in the cells in columns G:J? Formulas, data validation, values?

Did you try what I suggested?

 

[CMucha]

What is in the cells in columns G:J? Formulas, data validation, values?

Did you try what I suggested?

Nothing is currently in those cells at all.