Dependent Validation

[kop442000]

I want cell A1 to only allow values below 100 IF cell A2 = True.

If cell A2 = False, I want cell A1 to allow any value.

I've seen things about dependent validation (involving the INDIRECT function), but this seems to apply specifically if you want to choose from a list.

Thank you.

 

[ghrain22]

Try doing a custom data validation with the formula like this:
=IF(A2, A1<100,A1>100)