How is it Possible Q

[John]

How would it be possible to 'lock' cells from been input unless say a
certain value was in Column A?

I have a series of 30 rows each one would only be able to be input to
depending on if a certain value was in A etc. I would have 5 separate inputs
on each row, all would be 'locked' unless that certain value was in Column A

Hope that makes sense

Thanks

 

[RagDyer]

Not too much info !?!?

You could try "Data Validation".

For example, select B1 to F30, then:
<Data> <Validation>
Expand the "allow" window, and click on "Custom",
Then enter this in the formula window:

=$A1<>""

*Uncheck* the "Ignore Blank" box,
Then <OK>.

Now, you *cannot* enter any data in B1 to F30 *unless* the corresponding
cell in Column A contains any data.

You could stipulate a particular set of parameters for what Column A might
have to contain to allow data to be input into the other columns:

=LEN($A1)=5

=$A1>100

=$A1=$X$100

.... whatever
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

 

[John]

Thanks RagDyer, thats superb, I thought it might have required VBA stuff.
Just one Q what effect does the "" have in the formula (apart of course from
making it work1)?

 

[Silvabod]

It's basic math/logic. The conditional format in cell B1 relies on data
being in cell A1, else B1 remains blank too(will not accept data) - it
breaks down like this -.
IF cell A1 < (is less than) OR> (greater than) "" (=blank, or empty) ...cell
is active. The default is, UNLESS cell A1 contains data, B1 remains ""
(blank).
In this use, if cell A1 contains no data (is blank) then no data can be
entered in B1.
If cell A1 DOES contain data, then cell B1 is accessible for data.
layman's explanatiuon of what RagDyer told you!

There's two arguments - IF (greater or less than blank) cell is accessible,
ELSE "" (blank) - in effect, inaccessible for data input.