Prohibit data entry based on adjacent cell

[davemus]

[SOLVED]
I have the following formula in cell H2:
=AND(EXACT(G2,UPPER(G2)),(LEFT(G2)>="A")*(LEFT(G2)<="Z")*(MID(G2,2,1)>="0")*(MID(G2,2,1)<="9")*(MID(G2,3,1)>="A")*(MID(G2,3,1)<="Z")*(MID(G2,4,1)>="0")*(MID(G2,4,1)<="9")*(MID(G2,5,1)>="A")*(MID(G2,5,1)<="Z")*(MID(G2,6,1)>="0")*(MID(G2,6,1)<="9")*(LEN(G2)=6))

I would like to prohibit data entry in G2 if H2 reads "false" and allow data entry in G2 if H2 reads "true"

Hope someone can help

Davemus

[Winon]

Hello davemus,

Welcome to the Forum.

Apply Data Validation in Cell G2.

[:) Sixthsense :)]

Place the cursor in G2 cell
Press Alt+D+L
Settings>>Allow>>Select Custom
Formula>>Type

Please Login or Register  to view this content.

Press Ok>>Check by inputting entry in G2 cell